Re: [SQL] Moving from Transact SQL to PL/pgsql

2005-01-26 Thread George Essig
an openacs 5. George Essig ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] search facilities

2003-11-08 Thread George Essig
Download the latest version of PostgreSQL and look in the contrib/tsearch or contrib/tsearch2 directories. For documentation, see: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ http://sourceforge.net/mailarchive/forum.php?forum_id=7671 George Essig

Re: [SQL] connectby

2003-11-01 Thread George Essig
QL 7.2.3 and there was no contrib/tablefunc directory. You'll have to upgrade. George Essig ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [SQL] connectby

2003-10-27 Thread George Essig
in with the original table: SELECT t.*, description FROM connectby('menu','id','parent_id','2',0,'~') AS t(id integer, parent_id integer, level int, branch text), menu WHERE t.id = menu.id George Essig ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]