[ADMIN] Select Command in Procedures

2011-02-03 Thread Adarsh Sharma
Dear all, I am able to execute command successfully through CLI or pgAdmin . *create table user_news_new as select record_id,field_name,field_value,news_date from user_news where field_name in ('SOI','RelLoc','Description','Heading','news_date') and field_value != '' ; * But I don't know

Re: [ADMIN] Select Command in Procedures

2011-02-03 Thread Christian Ullrich
* Adarsh Sharma wrote: I am able to execute command successfully through CLI or pgAdmin . *create table user_news_new as select record_id,field_name,field_value,news_date from user_news where field_name in ('SOI','RelLoc','Description','Heading','news_date') and field_value != '' ; * But I

[ADMIN] Is there a batch/bulk UPDATE syntax available?

2011-02-03 Thread Gnanakumar
Hi, Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar to multirow VALUES syntax available for INSERT? INSERT Multirow VALUES syntax example: INSERT INTO films (code, title, did, date_prod, kind) VALUES ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'), ('HG120',

Re: [ADMIN] Is there a batch/bulk UPDATE syntax available?

2011-02-03 Thread Thomas Kellerer
Gnanakumar, 03.02.2011 13:00: Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar to multirow VALUES syntax available for INSERT? INSERT Multirow VALUES syntax example: INSERT INTO films (code, title, did, date_prod, kind) VALUES ('B6717', 'Tampopo', 110,

Re: [ADMIN] Is there a batch/bulk UPDATE syntax available?

2011-02-03 Thread pasman pasmański
Show us explain analyze for this update. 2011/2/3, Gnanakumar gna...@zoniac.com: Hi, Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar to multirow VALUES syntax available for INSERT? INSERT Multirow VALUES syntax example: INSERT INTO films (code, title, did,

[ADMIN] maximum rows to retrive

2011-02-03 Thread Antonio Biondo
Hi, i not found in query tool of PgAdmin III the option to set maximum rows to retrive. Is there no this option? -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Apri Conto Corrente Arancio entro

[ADMIN] PostgreSQL 9.0

2011-02-03 Thread Smith, Andy V
Hi We are looking to use PostgreSQL as a database for our development community and I would like to know if I can be guided to a list of packages and dependencies, which will allow me to install the product in a Red Hat Linux 5.5. environment. Thanks and regards, Andy V Smith CATE - Global

Re: [ADMIN] PostgreSQL 9.0

2011-02-03 Thread Devrim GÜNDÜZ
On Thu, 2011-02-03 at 13:10 +, Smith, Andy V wrote: We are looking to use PostgreSQL as a database for our development community and I would like to know if I can be guided to a list of packages and dependencies, which will allow me to install the product in a Red Hat Linux 5.5.

Re: [ADMIN] maximum rows to retrive

2011-02-03 Thread Guillaume Lelarge
Le 01/02/2011 18:44, Antonio Biondo a écrit : Hi, i not found in query tool of PgAdmin III the option to set maximum rows to retrive. Is there no this option? This option only exists in the data grid. If you need this in the query editor, add a LIMIT clause on your queries. -- Guillaume