Re: [SQL] Function returning setof taking parameters from another table

Marcin Stępnicki wrote: > So far the only method I can think of is to use union all with > different parametrs, like: > > select * from f_test(123) > union all > select * from f_test(124) > union all > select * from f_test(125); > > But it is not flexible, I'd like to have parameters stored in a

[SQL] How to change a view's owner in postgres

Dear All, How to change a view's owner in postgres? thanks in advance: Anoop

[SQL] How to change a view's owner in postgres(is it possible?)

Dear all, We can change the owner of a tbale like this alter table tbl_year_end owner to anoop; Is it possible to change the owner name of a view through sql?

Re: [SQL] How to change a view's owner in postgres

On Fri, Aug 1, 2008 at 11:41 AM, Anoop G <[EMAIL PROTECTED]> wrote: > How to change a view's owner in postgres? ALTER TABLE view_name OWNER TO new_owner; -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-s

[SQL] regexp_replace

Hi all. I'd like to know whether it's possible to reverse the behaviour of regexp_replace, meaning : now if I do SELECT regexp_replace ('foobarbaz', 'b..', 'X') I get 'fooXbaz' - it replaces the string that matches given pattern with 'X', how do I achieve the opposite - replace the string that does

Re: [SQL] regexp_replace

2008/8/1 Marcin Krawczyk <[EMAIL PROTECTED]> > Hi all. I'd like to know whether it's possible to reverse the > behaviour of regexp_replace, meaning : > now if I do > SELECT regexp_replace ('foobarbaz', 'b..', 'X') I get 'fooXbaz' - it > replaces the string that matches given pattern with 'X', how

Re: [SQL] regexp_replace

thanks / dzieki regards / pozdrowienia mk 2008/8/1 Pawel Socha <[EMAIL PROTECTED]>: > 2008/8/1 Marcin Krawczyk <[EMAIL PROTECTED]> >> >> Hi all. I'd like to know whether it's possible to reverse the >> behaviour of regexp_replace, meaning : >> now if I do >> SELECT regexp_replace ('foobarbaz', 'b

[SQL] Savepoints and SELECT FOR UPDATE in 8.2

I have a client application that needs: SELECT a set of records from a table and lock them for potential updates. for each record make some updates to this record and some other records in other tables call some call a function that does some application logic that does not access the da

Re: [SQL] column names with - and (

Hi Igor, Thanks for the info. I am using double quotes now and getting the result that I needed. Thank you, Maria On Tue, Jul 29, 2008 at 3:14 PM, Igor Neyman <[EMAIL PROTECTED]> wrote: > Maria, > > Try "" (double quotes: > > select x1 as "IL-a", x2 as "IL-a(p30)" from abc > > should help. >

Re: [SQL] Savepoints and SELECT FOR UPDATE in 8.2

On Fri, Aug 1, 2008 at 11:02 AM, EXT-Rothermel, Peter M <[EMAIL PROTECTED]> wrote: > > I was thinking of something like this: > > connect to DB > > BEGIN > > SELECT * FROM table_foo where foo_state = 'queued' FOR UPDATE; > for each row > do [ > >SAVEPOINT s; >UPDATE foo_resource SET in_use