On Thursday 13 Feb 2003 4:21 pm, Mintoo Lall wrote:
Hi Everybody ,
Is there a way in postgresql by which I can generate serial number column
for the resultset. I wanted the resulset to look like below
sno Name
---
1JOE
2JOHN
3
Ooops! Appologies to all for being sooo stupid!
I thought the order by was applied before the WHERE and if ordering in DESC
order for example would mean greater than and so on in the where clause
because I assumed meant it would appear before in the returned order.
Of course the where just
You can try Crimson Editor, a free powerful editor.
http://www.crimsoneditor.com/
Regards Frankie
Eduardo [EMAIL PROTECTED] wrote in message news:b2h2b0$uqd$[EMAIL PROTECTED]...
Do exists a PL/PGSQL editor?
Thanks.
---(end of
Eduardo,
Do exists a PL/PGSQL editor?
Not that I know of. We've talked about this for PGAccess, but nothing's come
of it because nobody has the motivation to code it, yet. PGAccess does have a
function editor, but it's rather limited.
I've been told that TOra (http://www.globecom.se/tora/)
Title: Passing arrays
How do you get an array of elements to be passed to a stored proc such that you can use the array in a SELECT statement in the WHERE clause
- e.g. WHERE field IN (array) etc...
CREATE OR REPLACE FUNCTION sp_report_retail_sales(int8[]) RETURNS SETOF
Micheal,
How do you get an array of elements to be passed to a stored proc such that
you can use the array in a SELECT statement in the WHERE clause
- e.g. WHERE field IN (array) etc...
There's no easy way, right now. You'll have to:
1) loop through the array and pass its elements to a
sorry about this - braindead and cannot find in doc. what's pg's
rownum pseudo-column or function name that returns the record number of
a set?
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
Chester,
sorry about this - braindead and cannot find in doc. what's pg's
rownum pseudo-column or function name that returns the record number of
a set?
There isn't one, unless there's something in /contrib that you can build.
--
Josh Berkus
Aglio Database Solutions
San Francisco
SQL92 says:
direct select statement: multiple rows ::=
query expression [ order by clause ]
[...]
3) Let T be the table specified by the query expression.
4) If ORDER BY is specified, then each sort specification in the
order by clause shall identify a column of
Where can I find a more detailed doc on how to write module for extended
datatype? There isn't much about it on techdoc.postgresql.org.
(I need to write one for UNIQUEIDENTIFIER.)
Thanks!
Wei
---(end of broadcast)---
TIP 5: Have you checked
Hi,
I've just upgraded my cygwin to 1.3.20-1 and postgresql to 7.3.2
And I found that when run
postmaster -i
There are three connections being established and why is that?
Administrator@DemoServer ~
$ LOG: database system was shut down at 2003-02-13 17:33:26 EST
LOG: checkpoint record
On Thu, 13 Feb 2003 17:50:22 -0500, Dmitry Tkach
[EMAIL PROTECTED] wrote:
Then it looks like postgres behaviour is still not compliant, if I read it correctly,
because
select x from mytable order by y;
should be invalid according to this, but works just fine in postres.
Yes, this is a Postgres
Try the SERIAL data type. It uses sequences and DEFAULT. Read the FAQ.
---
Wei Weng wrote:
Where can I find a more detailed doc on how to write module for extended
datatype? There isn't much about it on
Dmitry Tkach [EMAIL PROTECTED] writes:
Then it looks like postgres behaviour is still not compliant, if I read it
correctly, because
select x from mytable order by y;
should be invalid according to this, but works just fine in postres.
Yup, it's an extension --- as indeed is pointed out at
Roberto Mello [EMAIL PROTECTED] writes:
On Thu, Feb 13, 2003 at 09:02:05AM -0800, Josh Berkus wrote:
Unless you know something I don't, I do not believe that PL/pgSQL stores
execution plans for functions.
AFAIK execution plans for PL/pgSQL functions were cached once per backend.
No?
Yes.
How do you do a table Pivot in PostgreSQL?
tia,
.V
=
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Johnny,
Does postgres store execution plan's for user-defined SQL functions as the
PL/pgSQL interpreter does. And if so - will this only be prepared after an
initial call to the function? Can't seem to find this information in the
docs!? Thanks,
Unless you know something I don't, I do not
Because the WHERE clause is directly affected by the ORDER BY clause. If you
leave out the order by clause then the row count will be completely different
and therefore wrong. The ORDER BY clause is just as important as the WHERE
clause when counting rows. It should be possible to get a count
18 matches
Mail list logo