Re: default value based on select

Hello

On 05/04/2008, Pedro Doria Meunier <pdoria(at)netmadeira(dot)com> wrote:
> Hi,
>
> Is it possible to have a table's column default value set to some form of
> select?
>

directly no, but you can use function

postgres=# create table a(a integer);
CREATE TABLE

postgres=# create function mx() returns int as $$select max(a) from
a$$ language sql volatile;
CREATE FUNCTION
postgres=# create table b(x integer default mx());
CREATE TABLE

Regards
Pavel Stehule
> e.g. picking another table's value for a given SELECT ... WHERE ...
>
> Already thankful for any insight,
>
> --
> Pedro Doria Meunier
> Ips. da Olaria, Edf. Jardins do Garajau, 4, r/c Y
> 9125-162 Caniço
> Madeira - Portugal
> --------------------------------------------------
> Skype : pdoriam
> Mobile: +351961720188
>
>