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
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
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'm
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
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 from a table
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, the planner will ignore your
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
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
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
.
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
(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)---
TIP
!
Ezequiel Tolnay
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
13 matches
Mail list logo