Re: [SQL] Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???

2001-05-11 Thread Cliff Crawford
applies *after* ORDER BY, so you won't have this problem :) -- Cliff Crawford http://www.sowrong.org/ birthday party cheesecake jellybean BOOM ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

Re: [SQL] Dateadd

2001-05-04 Thread Cliff Crawford
; ?column? 2000-03-11 00:00:00-05 (1 row) -- Cliff Crawford http://www.sowrong.org/ birthday party cheesecake jellybean BOOM ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [SQL] SQL Dummy Needs Help

2001-03-12 Thread Cliff Crawford
* Cliff Crawford [EMAIL PROTECTED] menulis: SELECT table2.title_no, table2.paidto_date FROM table1, table2 WHERE table1.title_no=table2.title_no AND (date_part('month', table1.effect_date) != date_part('month', table2.paidto_date) OR date_part('day