Re: ?How create a one serial decimal(500,0) column or simulate it with bigint multicolumns serial?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Dani <danielcheagle(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: ?How create a one serial decimal(500,0) column or simulate it with bigint multicolumns serial?
Date: 2018-01-07 08:45:31
Message-ID: CAKFQuwZfUsFzcoyKuP4nq_zikjo30Y_+6Y3kaqTWuKPU-6LCSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Saturday, January 6, 2018, Dani <danielcheagle(at)gmail(dot)com> wrote:

> Hi! All!
>
> I Need create a one decimal serial column or simulate it with multiple
> columns of bigint.
>

You will need to write the logic yourself using an insert triggers -
default nextval(sequence-name) isn't going to work.

David J.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rounak Jain 2018-01-07 08:48:53 update master db with records from slave db
Previous Message Andreas Kretschmer 2018-01-07 08:27:21 Re: ?How create a one serial decimal(500,0) column or simulate it with bigint multicolumns serial?