Re: [SQL] Need Help for select

On Mon, 12 Aug 2002 08:11:48 -0700 (PDT) "Ludwig Lim" <[EMAIL PROTECTED]> wrote: Hi, thank you for your quick response, but the answer you gave me doesnt give the result i want. Let me try to explain what i want. Lets say that table a contains informations about some items of the type foo. Table

Re: [SQL] Few Queries

Am Mittwoch, 14. August 2002 07:05 schrieb Sugandha Shah: > 1. I 'm firing a query and it returns the value in variable which I > need to pass to other query . Is this a right way to pass the > value ? I'm newbie to this Database and hence facing lot of > syntax problems. > > CREATE FUNCTION

[SQL] Few Queries

  Hi ,     I'm still facing few problems and hence the query . I have searched the archives as well as read the manual.   1. I 'm firing a query and it returns the value in variable which I need to pass to other query .  Is this a right way to pass the value ? I'm newbie to     this Databas

Re: [SQL] [HACKERS] tsearch vs. fulltextindex

Well, I think it shouldn't disappear for a few releases yet... Chris > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian > Sent: Wednesday, 14 August 2002 12:43 PM > To: Christopher Kings-Lynne > Cc: Hackers; [EMAIL PROTECTED]; [EMAIL PRO

Re: [SQL] [HACKERS] tsearch vs. fulltextindex

Good point. Some said fulltextindex was better for certain queries, but if no one can come up with such a case, we can remove it. --- Christopher Kings-Lynne wrote: > Hi, > > I've just done some performance comparisons be

[SQL] tsearch vs. fulltextindex

Hi, I've just done some performance comparisons between contrib/fulltextindex and contrib/tsearch. Even with every optimisation I can think of for fulltextindex, tsearch is 300 times faster ;) Plus it doesn't require a separate table or complicated queries. I think we should strongly encourage

[SQL] concurrent connections is worse than serialization?

I have a testing program that uses 30 concurrent connections (max_connections = 32 in my postgresql.conf) and each does 100 insertions to a simple table with index. It took me approximately 2 minutes to finish all of them. But under the same environment(after "delete From test_table, and vacuum

Re: [SQL] update on a large table

Thanks Doug, I was doing an UPATE on 100 million rows and I was updating an indexed column, it was also the column that I was basing my seach on. UPDATE "Calls" SET "GroupCode"='100 my street' WHERE "GroupCode"='' AND "Site"='05' GroupCode was Indexed. I dropped the index and the query ra

[SQL] pg_dump's octal strings -> oracle data load

Hi, I am working on the oracle port of my pg application and my data load script contains \012 characters generated by pg. Anyone have any ideas on what to change these to so that: 1) oracle doesn't barf during the load (^M causes this... I'm loading from a -D flagged pg_dump sql script no

Re: [SQL] Delete function without knowing the elements

Use \df function_name to get the argument list and then drop it. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Atkins > Sent: Tuesday, August 13, 2002 12:30 PM > To: [EMAIL PROTECTED] > Subject: [SQL] Delete function without knowing the elem

[SQL] Delete function without knowing the elements

All, I created a function that I can't seem to delete. [no sure how many parameters] CREATE OR REPLACE FUNCTION insertEntry (int4, varchar, varchar, numeric, varchar, timestamp, varchar, int4, numeric, varchar, int4, ,) RETURNS INT4 AS ' .

Re: [SQL] Is this valid?

On Mon, 2002-08-12 at 23:58, Weiping He wrote: > Wei Weng wrote: > > >I am not sure if this is the right mailing list I talk to. Please let me > >know if I had violated any unwritten rules. :) > > > >I have a global variable PGconn* m_pgconn that is the connection handle > >for connecting to the

Re: [SQL] Conversion

On Tue, Aug 13, 2002 at 03:14:38PM +0800, Christopher Kings-Lynne wrote: > > http://www.postgresql.org/idocs/index.php?datatype-datetime.html says: > > > > The types abstime and reltime are lower precision types which are used > > internally. You are discouraged from using any of these types in

Re: [SQL] Function error

> Hi , > > Thanx a lot it worked . > > Is there any equivalent of dateadd function in postgres ? I highly recommend you actually read the Postgres manual's entries on date and time manipulation. You can just add intervals to dates: SELECT datefield + INTERVAL '1 month'; Chris ---

Re: [SQL] Function error

Hi , Thanx a lot it worked . Is there any equivalent of dateadd function in postgres ? Regards, -Sugandha - Original Message - From: "Janning Vygen" <[EMAIL PROTECTED]> To: "Sugandha Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 12:31 PM Subject: Re: [SQ