Vitaly Belman <[EMAIL PROTECTED]> writes:
> P.S Still a bit strange because "functions" IS in the search_path,
> there is no reason for it not to find it from the vacuum.
I see this in vacuumlo.c:
res = PQexec(conn, "SET search_path = pg_catalog");
regards, tom la
That was the problem. Thanks =).
P.S Still a bit strange because "functions" IS in the search_path,
there is no reason for it not to find it from the vacuum.
On 4/16/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Vitaly Belman <[EMAIL PROTECTED]> writes:
> > My bad. Here we go, really simple:
>
> > C
On Fri, Apr 15, 2005 at 21:58:31 +1000,
Alex <[EMAIL PROTECTED]> wrote:
> Hi,
>
> i have a table
>
> ProdId | LastUpdate
> ---+
> 100| 2005-04-01
> 100| 2005-03-01
> 100| 2005-02-01
> 200| 2005-04-01
> 200| 2005-03-01
> 200| 2005-02-01
>
> - How can i se
Vitaly Belman <[EMAIL PROTECTED]> writes:
> My bad. Here we go, really simple:
> CREATE OR REPLACE FUNCTION public.bayes_books(float4, int4)
> RETURNS float8 AS
> 'select bayes($1, $2, 5, 3.9)'
> LANGUAGE 'sql' IMMUTABLE;
> CREATE OR REPLACE FUNCTION functions.bayes(float4, in
My bad. Here we go, really simple:
-
CREATE OR REPLACE FUNCTION public.bayes_books(float4, int4)
RETURNS float8 AS
'select bayes($1, $2, 5, 3.9)'
LANGUAGE 'sql' IMMUTABLE;
ALTER FUNCTION public.bayes_books(float4, int4) OWNER TO postgres;
CREATE OR REP
On Tue, Mar 29, 2005 at 04:06:57PM -0600, Caleb Simonyi-Gindele wrote:
> Yes, we use it successfully with the SQL Server edition of our product.
> Does anyone know if this is available with Postgre?
> Caleb
Out of the box, the answer is, "No." It is not an insurmountable
problem, however, and I
Vitaly Belman <[EMAIL PROTECTED]> writes:
> Failed to check book_picture in table public.books:
> ERROR: function bayes(real, integer, integer, numeric) does not exist
> HINT: No function matches the given name and argument types. You may need to
> ad
> d explicit type casts.
> CONTEXT: SQL fun
We
have been using PostgreSQL on Mac OS X for about a year now. Ongoing monitoring
has proven very easy because the DBMS engine is so reliable, and mostly I use
phpPgAdmin, an extremely useful tool. However, its worth my while to make it
even easier. I would like a tool that would send an e
Thanks Tom, that's indeed what I needed.
However, I am having some problem with it. It goes:
--
Checking edition_picture in public.editions
Checking book_picture in public.books
Failed to check book_picture in table public.books:
ERROR: function bayes(real, integer, integer,
Am Freitag, 15. April 2005 17:57 schrieb Peter Eisentraut:
> Mario Weilguni wrote:
> > Is it possible to have a database cluster with one database being
> > UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)?
>
> No, sorry.
Thanks for the reply. Does that mean it's simply impossi
Mario Weilguni wrote:
> Is it possible to have a database cluster with one database being
> UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)?
No, sorry.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)
[EMAIL PROTECTED] wrote on 15.04.2005 16:42:
select max(lastupdate),prodid
from tablename
group by prodid
Even better :)
Thomas
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Wed, Apr 13, 2005 at 03:48:59PM -0700,
erico <[EMAIL PROTECTED]> wrote
a message of 112 lines which said:
> Lendo Lista de Pacotes... Pronto
> Construindo Árvore de Dependências... Pronto
Before posting on an english-speaking mailing list, I suggest to set
your locale to C... ("export LC_ME
Hrishikesh Deshmukh wrote:
Hi All,
I have a db in postgresql (Win, 8.0). Is there any software that i can
use to connect to DB and get ER diagram(pictures) of the DB!
Case studio, MS Access?
Thanks, in advance.
Hrishi
---(end of broadcast)---
TIP 3: i
select max(lastupdate),prodid
from tablename
group by prodid
-Original Message-
From: Thomas Kellerer <[EMAIL PROTECTED]>
Subj: Re: [GENERAL] SQL Question
Date: Fri Apr 15, 2005 7:24 am
Size: 621 bytes
To: pgsql-general@postgresql.org
On 15.04.2005 13:58 Alex wrote:
> Hi,
>
> i h
You would probably benefit from a quick search of the archives. There
are numerous tools for doing this.
On Apr 15, 2005, at 10:26 AM, Hrishikesh Deshmukh wrote:
Hi All,
I have a db in postgresql (Win, 8.0). Is there any software that i can
use to connect to DB and get ER diagram(pictures) of t
ok..so far i have compiled 8.02 and the previous 7.4.7 and both times
psql will permit creation of a database with CREATE DATABASE
dbname...etcand so onbut on glom when trying to interface to
postgresno matter what i enter...i can't create a database in my
home folder ...i don't know if
Hi All,
I have a db in postgresql (Win, 8.0). Is there any software that i can
use to connect to DB and get ER diagram(pictures) of the DB!
Thanks, in advance.
Hrishi
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send a
ok..so far i have compiled 8.02 and the previous 7.4.7 and both times
psql will permit creation of a database with CREATE DATABASE
dbname...etcand so onbut on glom when trying to interface to
postgresno matter what i enter...i can't create a database in my
home folder ...i don't know if
Is it possible to have a database cluster with one database being
UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)? I
checked a lot, and currently I found only the initdb way to influence
--lc-ctype and --lc-collate
Thanks!
Mario
---(end of broadcast
Dear sirs,,
I hope you all can help me. I am a average linux user . I manage to
install it and its main packages on a AMD 2,4 GHZ with 256 RAM MB.
Everything is working fine . I use a brazilian version, namely Linux
2.4.25-klg #1 SMP Ter Abr 6 09:28:24 BRT 2004 i686 GNU/Linux.
The problem is that
Ok but you haven't specify that and in your example there is no similar use
one solution is to change LastUpdate type and use timestamp.
to insert you make :
insert into test."tableProd" values (100, '2004-05-01 02:52:12') but it exists
other format for timesee postgresql doc for different
GIROIRE, Nicolas (COFRAMI) wrote:
For the first request (How can i select only the newest record for each ProdId
?), you can do :
select * from test."tableProd" u
where u."LastUpdate" = (select max(t."LastUpdate")
from test."tableProd" t
where u."ProdId" = t."ProdId")
Although this onl
On Fri, Apr 15, 2005 at 09:13:40AM -0300, Alejandro D. Burne wrote:
> Hi, I'm translating an app made with visual foxpro and mysql as rdbms
> to postgres.
> I've got many querys with this sintax:
>
> select code1, sum(if(cond1, price,0)), sum(if(cond2,price,0)) from ...
Use CASE WHEN cond1 THEN p
For the first request (How can i select only the newest record for each ProdId
?), you can do :
select * from test."tableProd" u
where u."LastUpdate" = (select max(t."LastUpdate")
from test."tableProd" t
wher
Hi, I'm translating an app made with visual foxpro and mysql as rdbms
to postgres.
I've got many querys with this sintax:
select code1, sum(if(cond1, price,0)), sum(if(cond2,price,0)) from ...
may be it's not sql compliant but very usefull
there is a way to do this work on postgres? I can't find
On 15.04.2005 13:58 Alex wrote:
> Hi,
>
> i have a table
>
> ProdId | LastUpdate
> ---+
> 100| 2005-04-01
> 100| 2005-03-01
> 100| 2005-02-01
> 200| 2005-04-01
> 200| 2005-03-01
> 200| 2005-02-01
>
> - How can i select only the newest record for each Prod
Hi,
i have a table
ProdId | LastUpdate
---+
100| 2005-04-01
100| 2005-03-01
100| 2005-02-01
200| 2005-04-01
200| 2005-03-01
200| 2005-02-01
- How can i select only the newest record for each ProdId ?
100| 2005-04-01
200| 2005-04-01
- How can i select
Marc G. Fournier wrote:
And, for Bittorrent Users, David has put up the tar packages at:
http://bt.postgresql.org
The windows installer torrent doesn't work.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: Have you searched our list archi
29 matches
Mail list logo
