Обсуждение: Looking for SKYLINE command
Hello, I have just installed version 8.4 of PostGresql in order to use SKYLINE command, but it seems that I get an error each time I try to use this command. Is there a specific plugin to install to add SKYLINE command ? Can you help me on this point to get this command working ? Thank you.
Le 04/08/2010 18:19, LaboRecherche a écrit : > > Hello, > > I have just installed version 8.4 of PostGresql in order to use SKYLINE > command, but it seems that I get an error each time I try to use this > command. > > Is there a specific plugin to install to add SKYLINE command ? Can you > help me on this point to get this command working ? > > Thank you. > > PS : I work on a Windows version of PostgreSQL.
On Wed, Aug 4, 2010 at 11:19 AM, LaboRecherche <nomail@altranx.com> wrote: > > Is there a specific plugin to install to add SKYLINE command ? Can you help > me on this point to get this command working ? > SKYLINE is not a command PostgreSQL has, and i think not even is in the SQL Standard. Seems like there is a patch to implement it but is for 8.3, look here http://skyline.dbai.tuwien.ac.at and here https://mail.google.com/a/systemguards.com.ec/#search/SKYLINE/11df7ce6b2658d1a Another discussion about if it is worth the effort is here https://mail.google.com/a/systemguards.com.ec/#search/SKYLINE/11118008c0ff75c8 -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL
LaboRecherche <nomail@altranx.com> writes:
> I have just installed version 8.4 of PostGresql in order to use SKYLINE
> command, but it seems that I get an error each time I try to use this
> command.
There is no SKYLINE command in any version of Postgres.
A couple of different people have shown work-in-progress patches that
add a function by that name, but those haven't gotten to the point of
being serious submissions and very likely wouldn't have been accepted
if they were. I'm not even sure that those did what you want anyway,
since there's no standard for such a feature.
regards, tom lane