Re: [SQL] Help
> Instead of "ctrl+z", press ":wq" (colon for command mode, w for write, q for > quit). If you are still mystified, "ctrl+z" stops a process running on a terminal, so it's likely that your vi is still running idle. Type 'fg' on the same terminal to bring it back. For more details on job control, see 'info sh' and search for 'jobs'. > This assumes that vi is your default editor. Which you can change by setting your EDITOR environment variable. For example, if your shell is bash, export EDITOR="emacs -nw" will do it. --Gene ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [SQL] New Type
> Hi all,
>
> I'm trying to create a type password; the goal is to have a table like:
>
> CREATE TABLE test (
> username varchar,
> pass passwd);
>
> insert into test values ('me','secret');
>
> and have "secret" being automagicly crypted.
>
> What I want is to mimic the PASSWORD function of mysql but much better,
> not having to call a function.
>
> I just can't figure how to write the xx_crypt(opaque) returns opaque
> function.
>
> Any help available???
Yes. Send me your code as a function that runs in a.out, I will
convert it. You will get in a form suitable for use as a contrib. You
will then be on your own. I'll do it in a split-second, but give me a
day or two to respond; I am moving and can't read my mail often enough.
--Gene
