Re: [SQL] good style?

2003-02-21 Thread Alan Gutierrez
, maybe. If you use join clauses you will be able to take control over your query, specifying what gets joined when. -- Alan Gutierrez - [EMAIL PROTECTED] http://khtml-win32.sourceforge.net/ - KHTML on Windows ---(end of broadcast)--- TIP 6: Have

Re: [SQL] double linked list

2003-01-30 Thread Alan Gutierrez
not sure how to declare a variable in PG in normal SQL. I don't do it that often, but when I do I do this: CREATE TEMPORARY TABLE Rightmost_Spread AS SELECT rightmost_spread FROM Frammis WHERE part = 'G'; I wonder what the alterntatives are? Alan Gutierrez - [EMAIL PROTECTED] http://khtml

Re: [SQL] SQL list table names

2003-01-08 Thread Alan Gutierrez
to see the SQL used to run \dt. Look at man psql for for info for just: psql -E template1 Alan Gutierrez ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] Re: Re: DateDiff, IsNull?

2001-08-15 Thread Alan Gutierrez
C++ here! Its just that C++ is what made my knee jerk. Thanks for showing me the value of operator overloading in PostgreSQL. Alan On Tue, 14 Aug 2001, Ross J. Reedstrom wrote: On Tue, Aug 14, 2001 at 06:51:33AM +, Alan Gutierrez wrote: Overloading operators? *Please* tell me

[SQL] Re: on update restrict

2001-08-14 Thread Alan Gutierrez
; is the thing prevented in your above example. I find it odd that you specify a restiction on one table in the definition of another table. Sorry, if this was a double post. Alan Gutierrez ---(end of broadcast)--- TIP 5: Have you checked our