Re: [SQL] update column with multiple values

-Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of ssylla Sent: Wednesday, February 08, 2012 9:31 PM To: pgsql-sql@postgresql.org Subject: [SQL] update column with multiple values Dear list, sorry, I already posted this, but it did

Re: [SQL] update column

UPDATE admin SET parent = SUBSTR(id,1,4); Doesn't it do what you want? Best, Oliveiros - Original Message - From: "ssylla" To: Sent: Thursday, February 09, 2012 1:58 AM Subject: [SQL] update column Dear list, sorry, I already posted this, but it did not seem to have been accepte

[SQL] update column with multiple values

Dear list, sorry, I already posted this, but it did not seem to have been accepted by the mailing list. So here's my second try: I need to update all rows of a column ('parent') based on a subquery that returns me the first four digits of another column ('id'): UPDATE admin SET parent=(SELECT SU

[SQL] update column

Dear list, sorry, I already posted this, but it did not seem to have been accepted by the mailing list. So here's my second try: I need to update all rows of a column ('parent') based on a subquery that returns me the first four digits of another column ('id'): UPDATE admin SET parent=(SELECT SU

Re: [SQL] problem with nested dblink function

I'm sorry, everything is in order. Today I looked with fresh eyes, a slight adjustment in the calling function and it works. Thanks for your attention. Best regards. Ps. recently I deal with postgresql and I wanted to consult with you. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org

[SQL] update multiple columns with multiple values

Dear list, I am trying to update all rows of a column ('parent') based on a subquery that returns me the first four digits of another column ('id'): After executing, I get the following error-message: I am not quite sure about that, but maybe I need to construct a function to fulfill this ta

[SQL] problem with nested dblink function

Hello everyone ! I have a problem with dblink function. I need to insert data using pl / pgsql function from one server to another. The data from server FS4 to server FS3. This code does not work: "select dblink ('dbname = ant_trendy port = 5433 host = FS3 user = postgres password = postgres ', '

Re: [SQL] Concurrent Reindex on Primary Key for large table

> -Original Message- > From: rverghese [mailto:ri...@hotmail.com] > Sent: Thursday, February 09, 2012 12:49 PM > To: pgsql-sql@postgresql.org > Subject: Re: Concurrent Reindex on Primary Key for large table > > Thanks! That worked. > > Any thoughts about containing index bloat. I thought