I'm working with an application I wrote which does something along these
lines:
SELECT ID FROM ITEM WHERE URL='X' FOR UPDATE
IF (ROW RETURNED) {
$ID = ITEM.ID
} ELSE {
SELECT nextval ('item_id_seq')
$ID = nextval
INSERT INTO ITEM
}
DO OTHER STUFF WITH $ID
So, I check if an it
On Fri, 8 Sep 2000, [iso-8859-1] Cristóvão Dalla Costa wrote:
> I'm working with an application I wrote which does something along these
> lines:
>
> SELECT ID FROM ITEM WHERE URL='X' FOR UPDATE
> IF (ROW RETURNED) {
> $ID = ITEM.ID
> } ELSE {
> SELECT nextval ('item_id_seq')
> $ID =
Sorry I didn't respond sooner -- lost the thread. :(
Yeah, I can see where you're seeing this now. Not so much
in the queries as in the code that needs to access the
results.
Your suggestion would work (theoretically the server could do
something similar in reverse (store a real name and low
hi,
i used to have an MSSQLServer database. I would like to ask how can i
port all the data from MSSQLServer to PostgreSQL.
TIA
