pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Bruce's Book and Built-in Functions
3+ messages / 3 participants
[nested] [flat]

* Bruce's Book and Built-in Functions
@ 2001-01-17 04:40 Josh Berkus <josh@agliodbs.com>
  2001-01-17 05:09 ` Re: Bruce's Book and Built-in Functions Brent Verner <brent@rcfile.org>
  2001-01-17 05:28 ` Re: Bruce's Book and Built-in Functions Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 2 replies; 3+ messages in thread

From: Josh Berkus @ 2001-01-17 04:40 UTC (permalink / raw)
  To: pgsql-sql

Folks,

Well, I now have a copy of Bruce's book on order.  Bruce, if
your sales have been slow, don't let A-W blame it on the
online draft.  According to Stacy's, it takes them an
average of 7 working days to get Ingram to cough up a new
copy, which is twice the normal period for tech books.  As a
result, they're out of stock a lot.

Plus www.postgresql.org could do a little more to promote
the book.  There's *still* nothing on the web site to tell
me the book's in print. HINT, HINT.

So, while I wait for my copy ... I can't find in the online
docs anywhere a comprehensive list of built-in functions.
You know, stuff like CURRVAL() and NOW().  Can anyone point
me to such a list?  Guessing parameters is getting
frustrating!

-Josh



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Bruce's Book and Built-in Functions
  2001-01-17 04:40 Bruce's Book and Built-in Functions Josh Berkus <josh@agliodbs.com>
@ 2001-01-17 05:09 ` Brent Verner <brent@rcfile.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Brent Verner @ 2001-01-17 05:09 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-sql

On 16 Jan 2001 at 20:40 (-0800), Josh Berkus wrote:

| So, while I wait for my copy ... I can't find in the online
| docs anywhere a comprehensive list of built-in functions.
| You know, stuff like CURRVAL() and NOW().  Can anyone point
| me to such a list?  Guessing parameters is getting
| frustrating!

psql -c '\df' > pg.functions

pg.functions will then contain a list of all registered functions,
return types, as well as parameters.

  b



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Bruce's Book and Built-in Functions
  2001-01-17 04:40 Bruce's Book and Built-in Functions Josh Berkus <josh@agliodbs.com>
@ 2001-01-17 05:28 ` Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2001-01-17 05:28 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-sql

[ Charset ISO-8859-1 unsupported, converting... ]
> Folks,
> 
> Well, I now have a copy of Bruce's book on order.  Bruce, if
> your sales have been slow, don't let A-W blame it on the
> online draft.  According to Stacy's, it takes them an

Sold 2,155 copies in the first month.  I know they think that is a good
sales number.  Having it online is clearly a win.

Frankly, I can't buy a book without seeing it.  I need to know it is
written in style that emphasizes concepts, rather than emphasizing
examples.

So, to choose a book, I either have to see it in a book store, or browse
it online.

> average of 7 working days to get Ingram to cough up a new
> copy, which is twice the normal period for tech books.  As a
> result, they're out of stock a lot.

They only printed 6k copies, so they went through >1/3 of the books in
the first month.  My guess is that they are trying to prioritize the
distribution.

> 
> Plus www.postgresql.org could do a little more to promote
> the book.  There's *still* nothing on the web site to tell
> me the book's in print. HINT, HINT.

Well, the web site mentions my book, and the book web page says it is in
print.

> 
> So, while I wait for my copy ... I can't find in the online
> docs anywhere a comprehensive list of built-in functions.
> You know, stuff like CURRVAL() and NOW().  Can anyone point
> me to such a list?  Guessing parameters is getting
> frustrating!

Sure, chapter 9 has it.  See the online version.  There is a huge table,
though currval is mentioned in the sequences chapter because it is not
like normal functions.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-01-17 05:28 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-17 04:40 Bruce's Book and Built-in Functions Josh Berkus <josh@agliodbs.com>
2001-01-17 05:09 ` Brent Verner <brent@rcfile.org>
2001-01-17 05:28 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox