Re: [GENERAL] how to alter an enum type

onnare values( 'dummy Q3', 'maybe' ); > INSERT 0 1 > postgres=# > postgres=# select * from questionnare; > q | a > --+--- > dummy Q1 | yes > dummy Q2 | no > dummy Q3 | maybe > (3 rows) > > postgres=# > > >

Re: [GENERAL] how to alter an enum type

Hi Richard, I actually want to change the enum values after I have created and associated it to a table colum. Is it possible? Thanks. On Mon, 24 Dec 2007 09:50:09 -0800 (PST) Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > --- On Mon, 12/24/07, Henrique Pantarotto <[EMAIL PROTE

[GENERAL] how to alter an enum type

Hi, I was wondering how can I alter an ENUM type? I have created a table like this: create type possible_answers as enum('yes', 'no'); create table questions ( question text, answers possible_answers); insert into questions values ('Do you like me?', 'yes'); So my question is... How can I chang

[GENERAL] Stored procedures returning multiple values... ?

It would be fun if stored procedured could return multiple values, wouldn't it? ;-) Thanks, ___ Henrique Pantarotto Administrador de Sistemas - SITE São Paulo Terra Networks Brasil S/A A Internet do Brasil agora é TERRA Tel: (11) 5505-5728 r.

[GENERAL] C function returning multiple values (or tuples)

+--+-+++---+--+-- this|is|a|splitted|text|divided|by|colons Is this what a "stored procedure" is? If it is, I'm with you, Yin-So. ;-) Thanks everybody!!! Regards from Brazil! -- Henrique Pantarotto CEPAnet Internet Provider webmaster / analista de sistemas Email: [EMAIL PROTECTED] Tel: (011) 5506-8477 Cel: (011) 9706-3444 LINUX FRIEND

Re: [GENERAL] encrypted field

Hello Greg, I've created a stupid little C trigger that is kinda like MySQL's "encrypt" function. I use it to store passwords in the UNIX crypt format. Here's the encrypt.c: ---- /* * * Henrique Pantarotto ([EMAIL P

Re: [GENERAL] Trigger documentation? Need more examples.. pleeeze.. ;-)

Zakkr, I love you. It worked!! Your help should keep me busy this weekend.. ;-) Thanks a lot.. I shall bug you again for sure.. j/k.. ;-) Henrique Pantarotto Sao Paulo, SP - Brazil On sex, 20 ago 1999, Zakkr wrote: > On Fri, 20 Aug 1999, Henrique Pantarotto wrote: > > > I w

Re: [GENERAL] Trigger documentation? Need more examples.. pleeeze.. ;-)

xamples ... why not: > ..see a /postgresql-6.5.1/contrib/spi directory in PostgreSQL source package. > > Zakkr -- Henrique Pantarotto CEPAnet Internet Provider webmaster / analista de sistemas Email: [EMAIL PROTECTED] Tel: (011) 5506-8477 Cel: (011) 9706-3444 LINUX FRIEND

Re: [GENERAL] Trigger documentation? Need more examples.. pleeeze.. ;-)

the one in the /test is rather complex (too complex?). > > However, PL/pgSQL may not be able to to external stuff, even C > can do that. -- I have the same problem, anybody'd ideas? > > > > > >From: Henrique Pantarotto <[EMAIL PROTECTED]> > >To: [EM

[GENERAL] Trigger documentation? Need more examples.. pleeeze.. ;-)

rectories, etc..). Is such thing possible? Someone has an example of this? ;-) Thanks a lot! Regards from Brazil! -- Henrique Pantarotto CEPAnet Internet Provider webmaster / analista de sistemas Email: [EMAIL PROTECTED] Tel: (011) 5506-8477 Cel: (011) 9706-3444 LINUX FRIEND