Re: [GENERAL] How to Import Excel Into PostgreSQL database

2008-12-24 Thread Ivan Sergio Borgonovo
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

[GENERAL] return query and function result type must be real because of OUT parameters

2008-12-24 Thread Ivan Sergio Borgonovo
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

Re: [GENERAL] return query and function result type must be real because of OUT parameters

2008-12-24 Thread Pavel Stehule
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/

[GENERAL] happy holidays, christmas etc.

2008-12-24 Thread Grzegorz Jaśkiewicz
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

[GENERAL] Multi-tenant cluster

2008-12-24 Thread Roderick A. Anderson
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

[GENERAL] pl/proxy and sequence generation

2008-12-24 Thread Igor Katson
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

Re: [GENERAL] pl/proxy and sequence generation

2008-12-24 Thread Jonah H. Harris
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

Re: [GENERAL] need some help with pl-pgsql

2008-12-24 Thread Adrian Klaver
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

Re: [GENERAL] need some help with pl-pgsql

2008-12-24 Thread justin
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

[GENERAL] Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress

2008-12-24 Thread Emanuel Calvo Franco
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

Re: [GENERAL] Multi-tenant cluster

2008-12-24 Thread Scott Marlowe
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. >

Re: [GENERAL] need some help with pl-pgsql

2008-12-24 Thread Scott Marlowe
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

Re: [GENERAL] lack of consequence with domains and types

2008-12-24 Thread Erik Jones
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,

Re: [GENERAL] Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress

2008-12-24 Thread Tom Lane
"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

Re: [GENERAL] lack of consequence with domains and types

2008-12-24 Thread Grzegorz Jaśkiewicz
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

Re: [GENERAL] lack of consequence with domains and types

2008-12-24 Thread Erik Jones
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

Re: [GENERAL] pl/proxy and sequence generation

2008-12-24 Thread Asko Oja
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

[GENERAL] Automatic CRL reload

2008-12-24 Thread Andrej Podzimek
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

[GENERAL] get the array value?

2008-12-24 Thread Charles.Hou
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: