On 23.08.2007, at 11:55, Albe Laurenz wrote:
CREATE FUNCTION b(status OUT integer, status_text OUT text)
LANGUAGE plpgsql STABLE STRICT AS
$$DECLARE
RENAME status TO out_status;
RENAME status_text TO out_status_text;
BEGIN
SELECT status, status_text
FROM a()
INTO out_statu
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Andreas" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, August 27, 2007 9:18 AM
Subject: Re: [SQL] List of FKeys ?
Andreas <[EMAIL PROTECTED]> writes:
could I get a list of foreign keys that refer to a column?
The information_
Hi,
Is there any function in postgre to know the size of the data in a
row of a table ?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruce Momjian wrote:
> Erik Jones wrote:
> On the way back, likewise I could pipe the tape through dd before
> giving it
> to pg_restore.
>
> Does pg_dump care what blocksize it gets? If so, what is it?
I assume you could pip
Jean-David Beyer wrote:
> >>> The main question is, If I present pg_restore with a 65536-byte
> >>> blocksize
> >>> and it is expecting, e.g., 1024-bytes, will the rest of each block get
> >>> skipped? I.e., do I have to use dd on the way back too? And if so,
> >>> what
> >>> should the blocksi
Kristo Kaiv <[EMAIL PROTECTED]> writes:
> From http://www.postgresql.org/docs/current/static/plpgsql-
> declarations.html#PLPGSQL-DECLARATION-RENAMING-VARS
> Note: RENAME appears to be broken as of PostgreSQL 7.3. Fixing this
> is of low priority, since ALIAS covers most of the practical uses of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruce Momjian wrote:
> Jean-David Beyer wrote:
> The main question is, If I present pg_restore with a 65536-byte
> blocksize
> and it is expecting, e.g., 1024-bytes, will the rest of each block get
> skipped? I.e., do I have to use dd
Hi there
I have a list of events that take place in a certain city at a certain
date. Now I would like to have the first two (ordered by date) events
for each city.
Is there a way to do this with one query?
I am using PostgreSQL 7.4.
Thanks for any tips.
Claudia
-
On Mon, 27 Aug 2007 18:36:47 +0200
Claudia Kosny <[EMAIL PROTECTED]> wrote:
> I have a list of events that take place in a certain city at a certain
> date. Now I would like to have the first two (ordered by date) events
> for each city.
>
> Is there a way to do this with one query?
> I am using
That's what I thought at first, but this is not the case. She's
looking for the first two dates in -each- city in the table. I
initially thought that this could be accomplished with GROUP BY and
LIMIT, but GROUP BY can only give you the first date for each city,
not the first two dates for
[Please don't top post as it makes the discussion more difficult to
follow.]
On Aug 27, 2007, at 12:34 , Joel Richard wrote:
On Aug 27, 2007, at 12:51 PM, D'Arcy J.M. Cain wrote:
On Mon, 27 Aug 2007 18:36:47 +0200
Claudia Kosny <[EMAIL PROTECTED]> wrote:
I have a list of events that take p
On Mon, 27 Aug 2007 13:34:09 -0400
Joel Richard <[EMAIL PROTECTED]> wrote:
> That's what I thought at first, but this is not the case. She's
> looking for the first two dates in -each- city in the table. I
> initially thought that this could be accomplished with GROUP BY and
> LIMIT, but GROU
On Aug 27, 2007, at 13:12 , Michael Glaesemann wrote:
select city, event, event_date, (
select count(event)
from events i
where i.city = o.city
and i.event_date < o.event_date
and event_date > current_date -- make sure they're future
events
This should be i.event
On 27.08.2007, at 18:07, Tom Lane wrote:
Kristo Kaiv <[EMAIL PROTECTED]> writes:
From http://www.postgresql.org/docs/current/static/plpgsql-
declarations.html#PLPGSQL-DECLARATION-RENAMING-VARS
Note: RENAME appears to be broken as of PostgreSQL 7.3. Fixing this
is of low priority, since ALIAS c
Good day.
I want to enter Postges into project,
which has so rectriction, that client should be written on Delphi (CBuilder).
Please, prompt me how to adjust Delphi to use Postgres.
Dmitry Turin
SQL4 (4.2.0) http://sql40.chat.ru
HTML6 (6.4.0) http://html60.chat.ru
Unicode2 (2.0.1
(1)Let's allow to __connect into several DBMS__ at once,
last of them becomes DBMS 'by default'.
User assign any nickname to each database at connection,
except nickname 'all' and 'local', e.g.
connect ra=database.remote.com username=Smith password=pwds nickname=db1;
connect ra=db.distination
16 matches
Mail list logo
