Re: [SQL] Asking GO on SQL SERVER

> Hem... I think postgresql do not like that. You may need to add a "COMMIT;" in there somewhere...? THINK BEFORE YOU PRINT - Save paper if you don't really need to print this ***Confidentiality and Privilege Notice*** The material contained in this message is p

Re: [SQL] update with join

2008/4/2, Ivan Sergio Borgonovo <[EMAIL PROTECTED]>: > I've > > create table types( > typeid int, > special boolean not null > ); > > create table methods( > methodid int, > typeid references types(typeid), > ); > > create table orders( > orderid int > ); > > create table order_pay

Re: [SQL] Asking GO on SQL SERVER

Hem... I think postgresql do not like that. For this example in function spEAR470. When "open Phasil for" not yet finishing, postgresql do "Delete from ear470_02 where sessid = Psess;". And this function becoming ERROR. But this case happen when this function call from 3 users in same time. Any sol

Re: [SQL] Asking GO on SQL SERVER

On Thu, Apr 3, 2008 at 7:14 AM, Otniel Michael <[EMAIL PROTECTED]> wrote: > Hi All.. > > Anybody knows what is "GO" (SQL Server) on Postgres? > If you are using the interactive terminal psql, then you can use \g meta command select 1+2 \g expect results here. Remember that this is a

Re: [SQL] Asking GO on SQL SERVER

Otniel Michael wrote: Hi All.. Anybody knows what is "GO" (SQL Server) on Postgres? Thanks. -- --- "He who is quick to become angry will commit folly, and a crafty man is hated" semi-colon. -- Sent via pgsql-sql mailing lis

[SQL] Asking GO on SQL SERVER

Hi All.. Anybody knows what is "GO" (SQL Server) on Postgres? Thanks. -- --- "He who is quick to become angry will commit folly, and a crafty man is hated"

[SQL] update with join

I've create table types( typeid int, special boolean not null ); create table methods( methodid int, typeid references types(typeid), ); create table orders( orderid int ); create table order_payments( payid int orderid references order(orderid), methodid references method(metho

[SQL] apparent RI bug

it appears I have a broken RI in my db. call_individual.clh_id references call_household.clh_id \d call_individual ... Foreign-key constraints: "call_individual_clh_id_fkey" FOREIGN KEY (clh_id) REFERENCES call_household(clh_id) ON DELETE CASCADE however: development=# select clh_id from cal

[SQL] A sys func for a->b, b->c => a->c ?

Good Morning, Someone has better solution about the following query situation? table test with two columns with primary key (id1, id2) id1, id2 = 12 13 12 3 13 5 Query conditions: = (1) a->b => b->a (2) a->b and a->c => a->c Expected return: id1 i