Dnia 2003-12-02 05:51, Użytkownik Kumar napisał:
Thanks for your reply.
But how to use this comma_aggregate( ) function to concatenate the fetched
columns values from a select statement. In my example my select stmt fetches
the following 3 rows. How can I use this function to concatenate them.
Sel
I'm getting an unexpected result using intervals in an expression:
select ('2003-10-26 0:00:00'::timestamp + '1 day'::interval)::date;
date
2003-10-26
(1 row)
When I get rid of the date cast it becomes clear what is happening:
select '2003-10-26 0:00:00'::timestamp + '1 day'::in
Thanks for your reply.
But how to use this comma_aggregate( ) function to concatenate the fetched
columns values from a select statement. In my example my select stmt fetches
the following 3 rows. How can I use this function to concatenate them.
Select full_name FROM project_members where project
Hi all-
I'm migrating to postgres from the MS SQL Server land, as I can see
a great potential with postgres, I was wondering if anyone has
experimented or started a project with XML inside user defined
functions?
I've seen the contrib/xml shipped with the distro, as I see it's
usefulness, it's no
Michalis Kabrianis writes:
> Schema | Table |Access
> privileges
> -+-+-
> cust| clients | {admin=a*r*w*d*R*x*t*/cust,"group salesmen=r
Hi
I hope this is the correct list to ask about a permissions problem I have.
I create a schema named cust, a table named clients, and a group named
salesmen.
I use:
REVOKE ALL ON SCHEMA cust FROM PUBLIC;
GRANT USAGE ON SCHEMA cust TO GROUP salesmen;
REVOKE ALL ON TABLE clients FROM PUBLIC;
GRANT
Dnia 2003-12-01 13:01, Użytkownik Kumar napisał:
Dear Friends,
I am doing a migration from SQL server to Postgres SQL. A simple select
fetches the following names.
select full_name FROM project_members where
project_members.project_role_id in (' + @p_res_ids + ') ;
Let us say if the results
Dear Friends,
I am doing a migration from SQL server to Postgres SQL. A
simple select fetches the following names.
select full_name FROM project_members where
project_members.project_role_id in (' + @p_res_ids + ') ;
Let us say if the results are
full_name
---
David
Postg
