Hi,
Do we have any replacement for REPLACE() of Oracle in PostGres? I know we can function to do same job. Regards Jomon -----Original Message----- From: Kris Jurka [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 1:52 PM To: Rod Taylor Cc: Jomon Skariah; [EMAIL PROTECTED] Subject: Re: [SQL] MINUS & ROWNUM in PostGres On Thu, 4 Sep 2003, Rod Taylor wrote: > > 2 Also I need to find an alternative for ROWNUM in oracle.. > > If you are looking for a unique identifier, try using the OID. > ROWID is oracle's unique identifier, ROWNUM is the row number in a query result. In the past it has been suggested that ROWNUM could be replaced by the nextval of a temporary sequence. Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
