Trace: ranking . ... CREATE OR REPLACE FUNCTION my_rank (tsvector, tsquery, int ) RETURNS float AS $$ use List::Util qw(min max); my ($string, $ query ) = @_; my $maxpos = 0; # Parse tsvector, taking into account positional information foreach (split / /, $string){ if(/^'(\w+)'(:([0-9,]+))?$/){ foreach(split /,/, $3){ $ vector {$_} = $1; $maxpos = max($maxpos, $_); } } } my @ vector = map {$ vector {$_}} sort {$a = $b} keys(% vector ); # Parse tsquery, assuming it to be ORed only $ ... SAI VO | ...

Storing and accessing the largest astronomical catalogues with the SAI CAS project S. Koposov1,2,3, O. Bartunov2, S. Karpov4 et al2. ... Why we want to build our own Catalogue Access Service The requirements for our CAS system The importance of the Database for the CAS (PostgreSQL & Q3C) The technical realization of CAS What has been already done Example of work TODO Storing and Accessing Astronomical Catalogues Existing projects CDS OpenSkyQuery CASjobs with SDSS They are all really great! ...