Try this
create view v(id) as select * from func(5);
if your function returns one column.
15.05.2012, 10:01, "Jan Bakuwel" :
> Hi,
>
> I've spend some time checking the documentation but haven't been able to
> find what I'm looking for.
> I've got a function that returns a set of integers and a
Hi,
I've spend some time checking the documentation but haven't been able to
find what I'm looking for.
I've got a function that returns a set of integers and a view that
selects from the function.
What I need is the ability to name the column in the view, ie.
create function func(i int) returns
Wes James writes:
> Why is there a different order on the different platforms.
This is not exactly unusual. You should first check to see if
lc_collate is set differently in the two installations --- but even if
it's the same, there are often platform-specific interpretations of
the sorting rule
I have postgresql 9.1.3 on a mac and on linux.
On the mac the results come out:
! *`-=[];',./~@#$%^&()_+{}|:"<>?\
then
\--\
On ubuntu 12.04 x64 it comes out (compiled and installed postgres from
tbz2 from postgresql.org repo):
\--\
then
! *`-=[];',./~@#$%^&()_+{}|:"<>?\
Why is there a dif
On Mon, 2012-05-14 at 17:25 +0530, Trinath Somanchi wrote:
> True, But it has its own stable version capable to handle this
> functionality
PGCluster was not a stable project.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant,
True, But it has its own stable version capable to handle this functionality
On Mon, May 14, 2012 at 5:23 PM, Devrim GÜNDÜZ wrote:
> On Mon, 2012-05-14 at 17:22 +0530, Trinath Somanchi wrote:
> > You can use PgCluster with Slony-II for this type of requirements.
>
> PGCluster is a dead project.
On Mon, 2012-05-14 at 17:22 +0530, Trinath Somanchi wrote:
> You can use PgCluster with Slony-II for this type of requirements.
PGCluster is a dead project.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified E
Hi-
You can use PgCluster with Slony-II for this type of requirements.
On Mon, May 14, 2012 at 11:02 AM, Steven Crandell wrote:
> Having all the dblink destinations on the same server makes it a much more
> viable option since the chances of the dblink update failing are greatly
> reduced.