[SQL] DELETE RETURNING

2006-10-21 Thread Daniel CAUNE
Hi, I have read in the future PostgreSQL 8.2 release note (http://developer.postgresql.org/pgdocs/postgres/release-8-2.html) that DELETE RETURNING will be supported. Tom, could please confirm that the following PL/PGSQL statements will work on PostgreSQL 8.2? INSERT INTO a(x, y) DELETE FRO

Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???

2006-10-21 Thread Alvaro Herrera
Joshua D. Drake wrote: > Berend Tober wrote: > > Devrim GUNDUZ wrote: > >> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > >> > >>> Can we convert from Postgres to Oracle !!??? > >> > >> Yes!!??? > > > > But of course, that begs the question: Why on earth would you want to!!?

Re: [SQL] Can we convert from Postgres to Oracle !!???

2006-10-21 Thread Devrim GUNDUZ
On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > Can we convert from Postgres to Oracle !!??? Yes!!??? -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hos

Re: [SQL] [HACKERS] Bug?

2006-10-21 Thread Richard Broersma Jr
> Then how do we clear the values of a serial column(is it done only by > dropping the column?)? If you look at the following link, you will see that serial is not really a true data-type. It is merely a short-cut to get the desired results: http://www.postgresql.org/docs/8.1/interactive/dataty