Re: [SQL] Private functions

2010-03-14 Thread silly sad
On 03/14/10 06:21, Jasen Betts wrote: On 2010-03-13, Gianvito Pio wrote: Hi all, is there a way to write a function that can only be called by another function but not directly using SELECT function_name ( )? not really. but there may be another way to get the effect you want. read the se

[SQL] Linked list with CTE

2010-03-14 Thread Mark Lubratt
Hello, I have a table in my database with multiple, independent linked lists. I would like to have a query that returns an entire linked list given a node (the node could be anywhere within the list). I found on the web an example of how to use CTEs to do this: http://wiki.postgresql.org/wiki