Re: [SQL] UPDATE and DELEte with a lot of register is to slow...

The problem is ... how to run the SCRIPT to the few? not all the 5 lines of update at the same time. John Evan Dizaro 2008/11/20 John Dizaro [EMAIL PROTECTED] I have to execute some times an UPDATE an some times a DELETE to register +- 5 , every time when i do that the database

[SQL] function - string ends with

Hello All: Is anyone aware of a function in PgSQL that will check if a string ends with a specific string? I.e. rposition(substring in string ) returns int Starts searching right to left within string Thanks for your attention to this matter. Kevin Duffy

Re: [SQL] BULK COLLECT

2008/11/21 Paul Dam [EMAIL PROTECTED]: Hoi, Is there an equivalent in PL/pgSQL for BULK COLLECT in PL/SQL of Oracle? I'm not that familiar with BULK COLLECT in oracle. What does it do? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription:

Re: [SQL] function - string ends with

Take a look at LIKE or ILIKE kd From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Duffy Sent: Friday, November 21, 2008 11:31 AM To: pgsql-sql@postgresql.org Subject: [SQL] function - string ends with Hello All: Is anyone aware

Re: [SQL] function - string ends with

If I understand what you need, I guess this clause does work. WHERE string LIKE '%substring' Best, Oliveiros - Original Message - From: Kevin Duffy To: pgsql-sql@postgresql.org Sent: Friday, November 21, 2008 4:30 PM Subject: [SQL] function - string ends with Hello

[SQL] simple text parsing function

Hello All: I am requesting your kind assistance with a simple text parsing function. The source code for the function is below. What is interesting is that the path through the code that actually does something works. The simple path through the code fails. For example select

[SQL] Interval Format

Hi everyone... im looking for some help with the interval format between two diferents versions of postgres I have instaled in my old server postgres 8.0.3 and in my new one postgres 8.3.5... Everything in both looks works nice but i notice a little difference that is taking my crazy.. I have

[SQL] JOIN results of refcursor functions

Hi, Is there any way to use INNER, LEFT and RIGHT JOIN between functions returning refcursor type. Explain: function1 as refcursor function2 as refcursor both functions return columns a and b. can i join the results of these functions in such manner (or any other): function3 as refcursor

Re: [SQL] Interval Format

Zagato [EMAIL PROTECTED] writes: I have som SQL that in 8.0.3 do: # SELECT '32 hours'::INTERVAL; interval - @ 1 day 8 hours (1 row) And in 8.3.5 do: seg_veh2=# SELECT '@ 32 hours'::INTERVAL; interval @ 32 hours (1 row) Why i unable to get my old

Re: [SQL] JOIN results of refcursor functions

Milan Oparnica [EMAIL PROTECTED] writes: Is there any way to use INNER, LEFT and RIGHT JOIN between functions returning refcursor type. No. Make them return setof whatever instead. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To

Re: [SQL] Interval Format

Hi this seems to works... but this will need to rewrite all my sql inPHP that uses interval can i make this default in postgres.conf or something similar... Thanks... Alan Jairo Acosta On Fri, Nov 21, 2008 at 9:15 PM, Tom Lane [EMAIL PROTECTED] wrote: Zagato [EMAIL PROTECTED] writes: