Hi list.
I'm closing this thread, and will re-post as separate questions.
I agree with Jorge that smaller mails will be easier to read.
David.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
On Wed, Jun 18, 2008 at 12:25 PM, Jorge Godoy <[EMAIL PROTECTED]> wrote:
> On Wednesday 18 June 2008 05:43:25 David wrote:
>> * Should I split this into separate threads instead of 1 thread for
>> all my questions?
>
> I would submit all of the questions in separate messages. It is tiresome to
> r
On Wednesday 18 June 2008 05:43:25 David wrote:
> Hi list.
>
> There are some database design-related issues I've pondered about for some
> time.
>
> But first:
>
> * Is this the correct list to ask these questions on?
>
> * Should I split this into separate threads instead of 1 thread for
> all my
Hi list.
There are some database design-related issues I've pondered about for some time.
But first:
* Is this the correct list to ask these questions on?
* Should I split this into separate threads instead of 1 thread for
all my questions?
Assuming there isn't a problem, here are my questions
On 4/4/06, Ottavio Campana <[EMAIL PROTECTED]> wrote:
hubert depesz lubaczewski wrote:> 2) do you think it's possible in a plpgsql procedure select the name of> a table into a variable and use that variable in the query?> possible, but not really good way. read about 'execute' in plpgsql.
hubert depesz lubaczewski wrote:
> 2) do you think it's possible in a plpgsql procedure select the name of
> a table into a variable and use that variable in the query?
> possible, but not really good way. read about 'execute' in plpgsql.
why isn't it good?
I mean, from my point of view
On 4/3/06, Ottavio Campana <[EMAIL PROTECTED]> wrote:
1) The database I'm going to develop is a big list with a catalog ofitems and I want to store subsets of this list representing theavailable items in several places.My idea is to create the big table with all the elements and then to
c
Alban Hertroys wrote:
> Ottavio Campana wrote:
>
>>> CREATE TABLE person (
>>> id SERIAL,
>>> name TEXT
>>> );
>
>
>> how can I do it with a INT8 instead of a INT4?
>
>
> Do you really expect that sequence to reach over 2 billion? Otherwise
> I'd stick with the SERIAL, nothin
Alban Hertroys wrote:
Ottavio Campana wrote:
CREATE TABLE person (
id SERIAL,
name TEXT
);
how can I do it with a INT8 instead of a INT4?
Do you really expect that sequence to reach over 2 billion? Otherwise
I'd stick with the SERIAL, nothing wrong with that unless you're
create table person (id serial8,name text);AlexOn 4/3/06, Alban Hertroys <[EMAIL PROTECTED]
> wrote:Ottavio Campana wrote:>> CREATE TABLE person (>> id SERIAL,
>> name TEXT>> );> how can I do it with a INT8 instead of a INT4?Do you really expect that sequence to reach over 2 billi
Ottavio Campana wrote:
CREATE TABLE person (
id SERIAL,
name TEXT
);
how can I do it with a INT8 instead of a INT4?
Do you really expect that sequence to reach over 2 billion? Otherwise
I'd stick with the SERIAL, nothing wrong with that unless you're selling
electrons sep
on 4/3/06 7:38 AM, [EMAIL PROTECTED] purportedly said:
> 1) The database I'm going to develop is a big list with a catalog of
> items and I want to store subsets of this list representing the
> available items in several places.
>
> My idea is to create the big table with all the element
--- Tomi NA <[EMAIL PROTECTED]> wrote:
> On 4/3/06, Ottavio Campana <[EMAIL PROTECTED]> wrote:
>
>
> > 3) faq 4.11.1 says
> >
> > >CREATE TABLE person (
> > >id SERIAL,
> > >name TEXT
> > >);
> > >
> > >is automatically translated into this:
> > >
> > >CREATE SEQU
On 4/3/06, Ottavio Campana <[EMAIL PROTECTED]> wrote:
3) faq 4.11.1 says>CREATE TABLE person (>id SERIAL,>name TEXT>);>>is automatically translated into this:>>CREATE SEQUENCE person_id_seq;
>CREATE TABLE person (>id INT4 NOT NULL DEFAULT nextval('person
Hello,
I'm designing a database and I'm having some problems, so I ask you a
suggestion.
1) The database I'm going to develop is a big list with a catalog of
items and I want to store subsets of this list representing the
available items in several places.
My idea is to create the big
15 matches
Mail list logo
