From: Martin Hart <martin@...>
Date: 2004-02-25T08:37:51+09:00
Subject: Re: PGresult#type (and other postgres questions)

On Tuesday 24 February 2004 22:59, Gavin Kistner wrote:
> I'm putting RDoc documents into postgres.c, and I have a few questions
> about what various methods do.
>
> PGconn.escape()
> PGconn.escape_bytea( ... )
> What do these two class methods do? (They're not documented in the
> supplied documentation. Neither is PGconn.quote either, but I figured
> that one out.)

Escape the supplied string so that it is valid SQL I believe - e.g. replace ' 
with either '' or \' (can't remember which)

> PGconn#notifies()
> What does this method do? (Not in the supplied documentation.)

This supplies information about the backend notifies waiting to be processed 
(see NOTIFY and LISTEN in postgres documentation)


Sorry for being terse and not answering everything - if nobody else has 
replied when I finish for the day, I'll send through a more detailed response 
:-)

NOTE - the last time I used ruby-postgres (just after pgsql 7.4 release) it 
was broken with Postgresql 7.4 in that the listen/notify stuff did not work 
properly.  It may have been patched since then - I'll dig through my notes 
from the time.

Cheers,
Martin

-- 
Martin Hart
Arnclan Limited
53 Union Street
Dunstable, Beds
LU6 1EX
http://www.arnclanit.com