Re: [SQL] [HACKERS] Bug?
> 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/datatype.html#DATATYPE-SERIAL Also, if you are interested in resetting your columns "serial" value back to 1 or 0 or -1, you can do it using the setval() function for the following link: http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html Regards, Richard Broersma Jr. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [SQL] Can we convert from Postgres to Oracle !!???
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 Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???
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!!??? > > Cost? > > Extensibility? > > The feeling that you won't at any moment be greeted by men in dark suits > wanting to audit your facilities? > > Using Open Source is cool? Maybe you are thinking of the opposite process!!??? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[SQL] DELETE RETURNING
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 FROM b RETURNING x, current_timestamp; IF NOT FOUND THEN -- No data were deleted actually END IF; Thanks, -- Daniel ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
