Re: [SQL] on error resume next

2009-07-31 Thread Andreas Wenk
Jasmin Dizdarevic wrote: hi, can i use savepoints to realize something like "on error resume next"? i've got the following situation: begin; 1. create view user001.accounts as select * from base.accounts; 2. grant select on user001.accounts to loginuser001; commit; begin; 3. create view

Re: [SQL] Table inheritance problem

2009-07-20 Thread Andreas Wenk
Gianvito Pio schrieb: Hello, I have 3 tables: persons, operators and persons_position. This is a semplified examples of their structures: CREATE TABLE persons (id varchar NOT NULL, CONSTRAINT "PK_Persons" PRIMARY KEY(id)); CREATE TABLE operators (id varchar NOT NULL, CONSTRAINT "PK_Oper

Re: [SQL] [PHP]

2009-03-07 Thread Andreas Wenk
inbox. More than messages <http://www.microsoft.com/windows/windowslive/> -- ------ Netzmeister St.Pauli St.Pauli - Hamburg - Germany Andreas Wenk Lutterothstr 82 20255 Hamburg Tel.: +49 (0) 40 319 43 54 http://www.netzmeister-st-pauli.de mailto:a.w...@netz

Re: [SQL] Check a column value not in Array.

2008-08-15 Thread Andreas Wenk
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi everybody, I was reading the mails concerning the subject "Check a column value not in Array" and made a quick test. This is the test table: test=# select * from values; id | item - +- 1 | a