name[] = { JOHN , ALEX , TEST ,""}
SQL : select name from table1 where 'TEST' = any (name)
return: { JOHN , ALEX , TEST }
in this sql command, how can i get the index of 'TEST' is 3 ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hello,
this is just a small wish / feature request.
The Apache httpd project dealt with a similar issue just a few months ago:
https://issues.apache.org/bugzilla/show_bug.cgi?id=14104 There's exactly the
same problem in PostgreSQL. The documentation says:
"The files server.key, server.crt, ro
On Wed, Dec 24, 2008 at 5:44 PM, Jonah H. Harris wrote:
> On Wed, Dec 24, 2008 at 10:18 AM, Igor Katson
> wrote:
> > So, should I make a wrapper in e.g. PL/pgsql for every insert function
> > writen in PL/Proxy to remove the sequence from the argument list and to
> call
> > the sequence generator
On Dec 24, 2008, at 12:04 PM, Grzegorz Jaśkiewicz wrote:
On Wed, Dec 24, 2008 at 6:12 PM, Erik Jones
wrote:
Yes, and columns have default values, too, which are not tied to
their
datatype's default value (if it even has one). ALTER TABLE
initializes rows
to have the new *column's* defaul
On Wed, Dec 24, 2008 at 6:12 PM, Erik Jones wrote:
> Yes, and columns have default values, too, which are not tied to their
> datatype's default value (if it even has one). ALTER TABLE initializes rows
> to have the new *column's* default. A column of some domain type could
> easily have some de
"Emanuel Calvo Franco" writes:
> But when i want to make, i recieved an error (make and
> /opt/SunStudioExpress/bin/dmake ):
> "...
> eca...@lastchance:~/Desktop/postgresql-snapshot$ sudo make
> You must use GNU make to build PostgreSQL.
What do you find unclear about that message? Install gmake
On Dec 22, 2008, at 1:08 PM, Grzegorz Jaśkiewicz wrote:
On Mon, Dec 22, 2008 at 6:10 PM, Erik Jones
wrote:
As mentioned above, by "fixing" the behavior to be what you're
expecting
you'd be breaking the defined behavior of ALTER TABLE.
I don't understand. The domain's have default values,
On Wed, Dec 24, 2008 at 9:32 AM, justin wrote:
>
>
> Found the problem at last. it was what i thought early this morning, the
> database had some flaky data set to null. so modified the the tables in
> question set defaults to zero and updated all the records that has null to
> zero. hopefully
On Wed, Dec 24, 2008 at 8:17 AM, Roderick A. Anderson wrote:
> I've done some searching using Google and found a few papers and articles on
> multi-tenant databases. I still have to read through many of them but there
> didn't appear to be much reference to using PostgreSQL in the ones I found.
>
Hi for everyone,
i download yesterday the ftp snapshot of the 8.4devel.
I configure with:
./configure --prefix=/usr/local/pg84devel
CC=/opt/SunStudioExpress/bin/cc CFLAGS="-xO3 -xarch=native \
-xspace -W0,-Lt -W2,-Rcond_elim -Xa -xildoff -xc99=none -xCC"
--with-perl --with-python --enable-dtrace
justin wrote:
Adrian Klaver wrote:
- "justin" wrote:
So it appears that something is causing _wipvalue to get set to NULL
somewhere else in the code. Now when running the failing select
statement manually works is because the modified record is still not
committed yet and its
On Tuesday 23 December 2008 9:57:01 pm justin wrote:
>
> I have taken your idea and made sure all the variables all appear the
> same and add raise notice for each portion of the command that is failing.
>
> -
> NOTICE: _wipvalue:
> CON
On Wed, Dec 24, 2008 at 10:18 AM, Igor Katson wrote:
> So, should I make a wrapper in e.g. PL/pgsql for every insert function
> writen in PL/Proxy to remove the sequence from the argument list and to call
> the sequence generator?
> Is there a better way to do that?
Why not put the sequence on yo
Hello!
The problem, i'm going to describe is about pl/proxy usage. I'll call
the bases, which are proxied to, the node-based and the base, which
contains pl/proxy the proxy-base.
The task, I need to accomplish, is to make an insert into node-bases,
using the sequence, generated inside the pr
I've done some searching using Google and found a few papers and
articles on multi-tenant databases. I still have to read through many
of them but there didn't appear to be much reference to using PostgreSQL
in the ones I found.
Can anyone suggest sources of information on this topic -- multi
My little attempt to create christmas tree:
WITH RECURSIVE tree(b, l, lv) AS
(
(
WITH RECURSIVE t(b, l) AS
(
select b/11.6, 0 AS l from (select generate_series(0,30)::float8
b union all select generate_series(30,0, -1)::float8 b) ziew
UNION ALL
select (b*1.06), l+1 FR
Hello
this is feature. Record needs two and more fields. So when is only one
out variable, then result must be scalar, etc -- setof float4.
regards
Pavel Stehule
it's little bit simple in 8.4, there you can define
create or replace function test.test() returns table(_rank float4) as $$
2008/
I was doing some test to track down an error in a more
complicated function and I stumbled in this behaviour I can't
understand:
create or replace function test.test(out _rank float4) returns setof
record as $$
begin
return query select 1::float4;
return;
end;
$$ language plpgsql stable;
and I ge
On Wed, 24 Dec 2008 01:43:36 -0600
Julio Cesar Sánchez González
wrote:
> Venkat Rao Tammineni escribió:
> Try with csv format and think it's going a nothing problem. See
> http://darkavngr.blogspot.com/2007/06/importar-datos-externos-nuestra-base-de.html
>
> for example.
If this doesn't come
19 matches
Mail list logo