Re: [SQL] PGSQL function for converting between arbitrary numeric bases?

2005-08-19 Thread Bruno Wolff III
On Mon, Aug 15, 2005 at 16:48:40 +0100, Simon Kinsella <[EMAIL PROTECTED]> wrote: > Hello, > > I'm looking - without luck so far - for a PGSQL function for converting > numbers between two arbitrary bases (typically base 10,16 and 26 in my > case). Something similar to the C 'strtol' function o

Re: [SQL] [SOT] pypgsql function receiving dictionary as parameter?

2005-08-19 Thread gherzig
Suppose this python structure: someDict = { 'field1': 'Foo', 'creepyfield': 'Bar' } and the connection to the database CONN = pg.connect() I want some pypgslq function CREATE myfunction ( __dictionary__) returns void AS (process) LANGUAGE pythonu an

Re: [SQL] [SOT] pypgsql function receiving dictionary as parameter?

2005-08-19 Thread Michael Fuhr
On Fri, Aug 19, 2005 at 10:13:20AM -0300, [EMAIL PROTECTED] wrote: > Hi all. Im a python programer, and im trying to use a dictionary > (associative array on Perl) in my pypgsql function without result. Anybody > know if it is possible? Please show a minimal but complete example of what you're try

[SQL] [SOT] pypgsql function receiving dictionary as parameter?

2005-08-19 Thread gherzig
Hi all. Im a python programer, and im trying to use a dictionary (associative array on Perl) in my pypgsql function without result. Anybody know if it is possible? Thanks a lot folks. -- Gerardo Herzig Direccion General de Organizacion y Sistemas Facultad de Medicina U.B.A. -

Re: [SQL] A Table's Primary Key Listing

2005-08-19 Thread Roger Tannous
OUPS !! Things seem to be stuck now, since the DB version is 7.3.2, so no array_to_string method is available. Does anyone have any idea how to solve that ? Regards, Roger Tannous. --- Roger Tannous <[EMAIL PROTECTED]> wrote: > Hi to all, there was a BIG MISTAKE in my proposition regarding my