Timothy Perrigo wrote:
Is there anything similar to pg_get_serial_sequence that will work with
tables that have an inherited serial column? (...)
Sorry, I should have searched before posting, I started a new thread.
Please refer to my solution posted today as "pg_get_serial_sequence and
in
the sequence for
the first column
that has a nextval for any sequence named [...]_seq, and regardless of
having the column been defined as serial or not.'
Please post comments, I think it can be further optimised and enhanced
quite a bit.
Cheers!
Ezequiel Tolnay
---(end of broadcast)---
TIP 6: explain analyze is your friend
Ezequiel Tolnay wrote:
(...) A function is meant to return a
result (or a set of results) of a predefined type *during* execution,
whilst a stored procedure (...)
I meant to say *after* instead of *during*. The capabilitie to return
results during execution could only be suported by stored
Chris Browne wrote:
kleptog@svana.org (Martijn van Oosterhout) writes:
On Mon, Jul 25, 2005 at 11:35:14AM +1000, Ezequiel Tolnay wrote:
Functions are not the same as stored procedures, but since PG lacks
stored procedures, there is a necessity to use functions instead.
Ok, maybe I&#
ading features.
Please have a look at my reply to the sister thread.
Cheers,
Ezequiel Tolnay
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
d be great if
PG had not only its own special and unique features, but also all the
common features you would find in other RDBMSs, for portability and
convenience.
Cheers,
Ezequiel Tolnay
---(end of broadcast)---
TIP 9: In versions below 8.0
Jim C. Nasby wrote:
On Thu, Jul 21, 2005 at 07:10:03PM +1000, Ezequiel Tolnay wrote:
* Allow FETCH command to be used with CREATE TABLE tab AS qry (in place
of qry)
I'm not really clear on what you're looking for here..
Fetching from a cursor should be equivalent to selecting fr
overloading.
Cheers,
Ezequiel Tolnay
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Martijn van Oosterhout wrote:
On Thu, Jul 21, 2005 at 07:10:03PM +1000, Ezequiel Tolnay wrote:
* Make temporary schemes visible (and accessible) only to its current
owner/user, and create a tool to clear currently unused temporary
schemes (for instance during backups, or when duplicating a
Benjamin Smith wrote:
Now, I want to get a result like:
classroom | students | seats
101A 0 25
101B22 30
102A11 0
... etc.
Something somewhat akin to
select classroom.title,
count(students.id) AS students,
count(seats.id) AS seats
from classrooms, students, seats
wh
g any additions. So any hints
of how to become a PG developer to submit changes, and where to start
(or what documentation to read first) to have a fast head-start will be
highly appreciated.
Cheers,
Ezequiel Tolnay
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hi everyone! I'd like to post a few features I'd like to see in coming
releases. Does anyone know about a wishlist newsgroup or web page, or
whoat is the proper way to propose such requests?
Thanks,
Ezequiel Tolnay
---(end of broadcast)-
dmins. Please pg-wizards, lend me a
hand with this!
Cheers!
Ezequiel Tolnay
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
13 matches
Mail list logo
