Re: [SQL] Query-ing arrays

2000-09-01 Thread Jon Lapham
iterate a scalar operator over the elements of the array and the value, and compute a result as the logical OR or AND of the iteration results." -- -**-*-*---*-*---*-*---*-*-*-----*---*-*---*-*-*-*-*--- Jon Lapham Centro Nacional de Ressonancia Magnetica Nuclear de Macromo

[SQL] Query-ing arrays

2000-09-01 Thread Jon Lapham
ause I do not know that the 'xxx' will always be in the 4th position. Suggestions? TIA, Jon -- -**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*-*--- Jon Lapham Centro Nacional de Ressonancia Magnetica Nuclear de Macromoleculas Universidade Federal do Rio de Janeiro (UFRJ) - Brasil email: [EMAIL PROTECTED] ***-*--**---***---

Re: [SQL] on line numbers, drop table errors, and log files

2000-08-02 Thread Jon Lapham
to make all my tables, then the "-a" output of pg_dump would fill the database with data. As I said, your solution works, thanks, I'm just puzzled why my way didn't. Later, Jon -- -**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*-*--- Jon Lapham Centro Nacional de Ressonancia Magnetica Nuclear de Macromoleculas Universidade Federal do Rio de Janeiro (UFRJ) - Brasil email: [EMAIL PROTECTED] ***-*--**---***---

[SQL] on line numbers, drop table errors, and log files

2000-08-01 Thread Jon Lapham
backup.dump" file to place "drop sequence" statements before the "create sequence" statements because they are created by my "create_tables.sql" script. I'm sure you Postgres gurus out there are not doing it this way, what is your method of database backup/

Re: [SQL] Why do I need to set UPDATE permissions for fkey check?

2000-07-21 Thread Jon Lapham
with a (gulp) permissions switching trigger (gulp)? -- -**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-*-*-*-*--- Jon Lapham Centro Nacional de Ressonancia Magnetica Nuclear de Macromoleculas Universidade Federal do Rio de Janeiro (UFRJ) - Brasil email: [EMAIL PROTECTED] ***-*--**---***---

[SQL] Why do I need to set UPDATE permissions for fkey check?

2000-07-21 Thread Jon Lapham
uot;} work | {"=arwR"} template1=> INSERT INTO work (info) VALUES (1); INSERT 331226 1 -- -**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*-*--- Jon Lapham Centro Nacional de Ressonancia Magnetica Nuclear de Macromoleculas Universidade Federal do Rio de Janeiro (UFRJ) - Brasil email: [EMAIL PROTECTED] ***-*--**---***---