Re: [SQL] what's wrong in this procedure?

or replace function get_historico() RETURNS SETOF twiste.type_cur__historico AS $$ instead of create or replace function get_historico() RETURNS SETOF twiste.type_cur__historico AS ' together with the corresponding $$ language 'sql'; instead of ' language 'sql'; at

Re: [SQL] Using SKYLINE command on PostgreSQL

introduced and maybe that makes writing these kinds of queries easier. Also the knngist ordering of 'interesting points' might be a solution for problems in the same ballpark. regards, Yeb Havinga

Re: [SQL] Table Design for Hierarchical Data

Leif Biberg Kristensen wrote: On Monday 12. April 2010 16.57.38 Rob Sargent wrote: Believe me: "ego-ma-pa" will correctly define genealogical relationships (at least among humans). Yes, but a family tree is not a hierarchical tree as defined in database theory. Believe me: I'm a genea

Re: [SQL] Table Design for Hierarchical Data

Achilleas Mantzios wrote: Στις Wednesday 07 April 2010 23:33:07 ο/η Yeb Havinga έγραψε: Achilleas Mantzios wrote: Στις Wednesday 07 April 2010 11:06:44 ο/η Yeb Havinga έγραψε: Achilleas Mantzios wrote: You could also consider the genealogical approach, e.g

Re: [SQL] Table Design for Hierarchical Data

Achilleas Mantzios wrote: Στις Wednesday 07 April 2010 11:06:44 ο/η Yeb Havinga έγραψε: Achilleas Mantzios wrote: You could also consider the genealogical approach, e.g. The parents of any node to the root, i.e. the path of any node to the root are depicted as parents[0] : immediate

Re: [SQL] Table Design for Hierarchical Data

? regards, Yeb Havinga -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Howto have a unique restraint on UPPER (textfield)

e key value violates unique constraint "ai" regards, Yeb Havinga -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] selecting rows tagged with "a" but not "b"

Andreas Kretschmer wrote: 8q5tmky...@sneakemail.com <8q5tmky...@sneakemail.com> wrote: Hi, I have a two tables: article articleID, name, content tags articleID, tag I want to find all articles that are tagged with "a" but not "b" how do I do this? select a.* from article left joi

Re: [SQL] Multiple simultaneous queries on single connection

Hello Craig, list Is there a way to have two or more connections see each others uncommitted things? Not at present. You should be able to use explicitly declared cursors and FETCH to interleave requests for results from one or more queries in the same transation using the one connection, bu

[SQL] Multiple simultaneous queries on single connection

multiple connections. The problem is that multiple connections (from the same application instance) do not share the same MVCC snapshot. Is there a way to have two or more connections see each others uncommitted things? Any thoughts? Yeb Havinga -- Sent via pgsql-sql mailing list (pgsql-sql