As long as your input is well-defined, you could certainly do something
like this in a trigger.
Instinctively, I would think that plperl might be a little more wieldy
than plpgsql for the required parsing, but I'm pretty sure a plpgsql
solution could be created. Don't have one handy, though...
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
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
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 ProdId ?
100
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
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
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 price
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 only
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
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
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
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
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
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 have
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:
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
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
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
[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
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
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 impossible,
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,
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
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 function
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 can
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
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, int4,
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 select only the
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:
CREATE OR
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 lane
30 matches
Mail list logo