from:"Beth"

Re: [SQL] cannot create function that uses variable table name

2003-01-23 Thread Beth

Thanks for your reply David... 1)The "" round Retired are to label the column/field 'Retired' rather than 'retired' (someone else created the database with Upper case titles!) 2) Your code is correct.. cept that single quotes have to be escaped(?!) so the following will do the trick when updating

Re: [SQL] cannot create function that uses variable table name

2003-01-23 Thread Beth

guage 'plpgsql'; which has: parse error at or near "true" ($1 is the filename, $2 is the fieldname, $3 is the fieldvalue and "Retired" is a boolean field in each of the files) Thanks Beth ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] indexing on char vs varchar

2002-10-02 Thread Beth Gatewood

Thanks for the excellent description, Josh. And the reminder of the performance list (it's existence somehow slipped from my mind). -Beth > -Original Message- > From: Josh Berkus [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 02, 2002 10:56 AM > To: Beth Gatewoo

Re: [SQL] indexing on char vs varchar

2002-10-02 Thread Beth Gatewood

SorryI don't understand. The length is at the front of what? -Beth > -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 02, 2002 10:06 AM > To: Beth Gatewood > Cc: [EMAIL PROTECTED] > Subject: Re: [SQL] inde

[SQL] indexing on char vs varchar

2002-10-02 Thread Beth Gatewood

=oracle+char+vs+varchar+index&hl=en&lr=&ie= UTF-8&oe=UTF-8&selm=3a791aa3%40news.iprimus.com.au&rnum=1) Thanks for explaining this to me -Beth ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] writing a function to mimic mysql last_insert_id

2002-09-11 Thread Beth Gatewood

was to trying to avoid having the developers make a lot of sql revisions to their application. Thanks-Beth > -Original Message- > From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 7:05 PM > To: Beth Gatewood; [EMAIL PROTECTED] > Su

Re: [SQL] writing a function to mimic mysql last_insert_id

2002-09-11 Thread Beth Gatewood

to save the perl developers the pain of having to go in and modify a bunch of their SQL to call out to seq.currval, I thought I would attempt to mimic this function. Perhaps there is another way to approach this than writing this type of function? Thanks! Beth > -Original Message- >

[SQL] writing a function to mimic mysql last_insert_id

2002-09-11 Thread Beth Gatewood

ers on how to tackle this problem (and if it is possible ;-) I am thinking that I need to store in a table for each transaction whatever autoincremented values were created (which they are for all my primary keys) -Beth ---(end of broadcast)--

Re: [SQL] make a unique index for foreign keys?

2002-06-13 Thread Beth Gatewood

does - sure you're not getting mixed up there? You are absolutely right! I am confused I did the actual test //create the tables beth=> create table parent(pk INTEGER primary key); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parent_pkey' for tab