Re: [SQL] FK Constraints, indexes and performance

--- 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 > Th

Re: [SQL] create new field

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

Re: [SQL] create new field

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

Re: [SQL] Multiple table join

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.Loca

Re: [SQL] Multiple table join

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 <[

[SQL] create new field

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 an

[SQL] suggestion needed for implementation

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 d

Re: [SQL] Multiple table join

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 tab

[SQL] Multiple table join

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] Converting Query from MS SQL

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' WHER

Re: [SQL] output

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 <[EM

[SQL] Converting Query from MS SQL

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 IN (" + @p_list_ids + ");" EXEC(@v_sql)