Re: [SQL] output

2003-10-06 Thread Popeanga Marian
Popeanga Marian wrote: I am using libpg inside a plugin. For oracle conections i can read the server output with this package dbms_output.read_line (... ). For pgsql is something similar for reading server output ? Tom Lane wrote: Popeanga Marian [EMAIL

Re: [SQL] Converting Query from MS SQL

2003-10-06 Thread Richard Huxton
On Monday 06 October 2003 14:04, Kumar wrote: Dear Friends, I am working with Postgres 7.3.4 on RH Linux 7.2. While migrating all the SPs (from MS SQL Server), I come across these lines in MS SQL Server procedure. SET @v_sql = UPDATE Schema1.employee SET rec_deleted_flag = 'Y' WHERE empid

[SQL] Multiple table join

2003-10-06 Thread Louise Cofield
Greetings, SQL gurus! I am attempting to select fields Location and Item_Num from table A where A.Location = B.Location, AND select Item_Description from table C, where A.Item_Num = C.Item_Num. Any help would be appreciated. Louise

Re: [SQL] Multiple table join

2003-10-06 Thread Bruno Wolff III
On Mon, Oct 06, 2003 at 10:26:59 -0600, Louise Cofield [EMAIL PROTECTED] wrote: I am attempting to select fields Location and Item_Num from table A where A.Location = B.Location, AND select Item_Description from table C, where A.Item_Num = C.Item_Num. Just list all three tables in

[SQL] suggestion needed for implementation

2003-10-06 Thread Wei Weng
I need to create triggers on a number of tables that have full text search capability. The trigger, basically, needs to call select set_curcfg('default') first to set the locale , then call tsearch2 function on the text columns in the table to update the index. How can I implement a trigger that

[SQL] create new field

2003-10-06 Thread Chris Faulkner
Hello I would like to change the type of a column. At the moment, it is varchar(4) but I would like it to be int. All values in the field at the moment are actually integer. I tried a way I had seen in the archives - it foes along the lines of adding a column, using update, drop the old column

Re: [SQL] Multiple table join

2003-10-06 Thread Louise Cofield
That was way too simple -- thank you! -Original Message- From: Bruno Wolff III [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 10:38 AM To: Louise Cofield Cc: [EMAIL PROTECTED] Subject: Re: [SQL] Multiple table join On Mon, Oct 06, 2003 at 10:26:59 -0600, Louise Cofield

Re: [SQL] Multiple table join

2003-10-06 Thread Dan Langille
On 6 Oct 2003 at 10:26, Louise Cofield wrote: I am attempting to select fields Location and Item_Num from table A where A.Location = B.Location, AND select Item_Description from table C, where A.Item_Num = C.Item_Num. Try: select Location, Item_Num from table A, B, C where A.Location

Re: [SQL] create new field

2003-10-06 Thread Josh Berkus
Chris, template1=# update tab set new_col = OLD_COL::int4; ERROR: Cannot cast type character to integer I understand this - some tables might have characters in the varchar but how to get around it in my case ? I know that my character field has only integers in it ? Actually, you just

Re: [SQL] create new field

2003-10-06 Thread Bruno Wolff III
On Mon, Oct 06, 2003 at 17:35:11 +0100, Chris Faulkner [EMAIL PROTECTED] wrote: OK - so I tried casting. template1=# update tab set new_col = OLD_COL::int4; ERROR: Cannot cast type character to integer I understand this - some tables might have characters in the varchar but how to

Re: [SQL] FK Constraints, indexes and performance

2003-10-06 Thread ow
--- Tom Lane [EMAIL PROTECTED] wrote: It looks to me like the 7.3 planner will not choose indexscans for the FK check queries in this example, because the comparison operators are misconstrued as shown in this thread: http://archives.postgresql.org/pgsql-hackers/2003-03/msg00997.php The