I've got a process that every minute or so selects some data from a number of
tables. At the minute i dump this into a normal table, where i do some more
processing with it before truncating the table and starting again.. I don't
have any indexes on the temporary table but have thought about add
Anyway, this is in response to a really old request of mine to easily
and automatically get a datestyle for a different DBMS as part of an
ongoing port process
(http://archives.postgresql.org/pgsql-sql/2008-05/msg00048.php).
I patched this a while ago and I finally got a chance to test it.
Overall
Hi,
I'm not to sure this is possible.
I need to replace a primary key (pkid) with the value of a different field.
I have
pkid = 200
attendid = 301
I need the pkid = 301
But there may or may not be a pkid that already exist that has the value of
301. The attendid is unique and the pkid data
In response to johnf :
> Hi,
> I'm not to sure this is possible.
>
> I need to replace a primary key (pkid) with the value of a different field.
> I have
> pkid = 200
> attendid = 301
>
> I need the pkid = 301
>
> But there may or may not be a pkid that already exist that has the value of
>
