Re: [SQL] Performance issue

2004-04-30 Thread Tom Lane
"Michael L. Hostbaek" <[EMAIL PROTECTED]> writes: > I cron script is being run every night (while very low db activity), > that deletes all rows from the table, and injects a bunch of new data... You should vacuum in between ... or even better, do the deletion with TRUNCATE.

Re: [SQL] Permissions not working

2004-04-30 Thread Pallav Kalva
Tom Lane wrote: Pallav Kalva <[EMAIL PROTECTED]> writes: usps=> \z citystate_alias Access privileges for database "usps" Schema | Table | Access privileges +

Re: [SQL] isnumeric() function?

2004-04-30 Thread Frank Bax
At 11:29 AM 4/30/04, Yudie wrote: Great the function works, but what does it means? SELECT $1 ~ ''^[0-9]+$'' Yudie The ~ is a pattern matching operator. ^ matches beginning of string [0-9] matches any numeric digit 0 thru 9. + matches one or more occurrences of what came be

Re: [SQL] Permissions not working

2004-04-30 Thread Tom Lane
Pallav Kalva <[EMAIL PROTECTED]> writes: > usps=> \z citystate_alias > Access privileges > for database "usps" > Schema | Table > | Access privileges > +-+---

Re: [SQL] isnumeric() function?

2004-04-30 Thread Yudie
Great the function works, but what does it means? SELECT $1 ~ ''^[0-9]+$'' Yudie - Original Message - From: "Jeff Eckermann" <[EMAIL PROTECTED]> To: "Yudie" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, April 30, 2004 9:11 AM Subject: Re: [SQL] isnumeric() function? --- Yudie

Re: [SQL] isnumeric() function?

2004-04-30 Thread Jeff Eckermann
--- Yudie <[EMAIL PROTECTED]> wrote: > What is isnumeric function in postgresql? > I'm using psql version 7.2.2 > thanks > Yudie I don't think that function is included as such. But you could do something like: CREATE FUNCTION isnumeric(text) RETURNS boolean AS ' SELECT $1 ~ ''^[0-9]+$'' ' LANG

Re: [SQL] Problem in SQL Trigger

2004-04-30 Thread Rajesh Kumar Mallah
Can you tell us about the postgresql versions in 7.3 and 9.0 also post the actuall error message from postgresql. regds mallah. Ramesh Patel wrote: Hi i have one problem in Trigger. this trigger alread work on Red Hat Linux 7.3 but now i shift to RHL9.0 in RHL 9.0 not working . in this problem in

Re: [SQL] Permissions not working

2004-04-30 Thread Pallav Kalva
Tom Lane wrote: Pallav Kalva <[EMAIL PROTECTED]> writes: I have a database for ex: 'ups' and it was owned previously by 'postgres(superuser)' but now i have changed the ownership to new user 'ups' all the tables are owned by these user 'ups'. That isn't a supported operation. How did you

Re: [SQL] Check a value in array

2004-04-30 Thread Marco Lazzeri
Il gio, 2004-04-29 alle 19:56, Rod Taylor ha scritto: > On Thu, 2004-04-29 at 13:37, Marco Lazzeri wrote: > > Hi all. > > > > I have to check if a value is in an array. > > > > I've got a date array in a table and I would like to perform queries > > like: > > > > SELECT * FROM table WHERE date I

Re: [SQL] Use arrays or not?

2004-04-30 Thread Achilleus Mantzios
Just some comments from my experience: PgSQL Arrays are mainly for modeling arrays not relations. Arrays can be very useful if they are not ever gonna be treated as relations and if performance is an issue (e.g. dynamic graphs, on the fly statistics etc..). Also (besides other solutions) int[]