Thread: Logical Fields in postgres.

Logical Fields in postgres.

From
"dlangschied"
Date:
'Lo all,
How do I create a logical field in postgres?  These fields were not
recognized when I tried to load them.

Sincerely,

David Langschied
Langschied Consulting Services
25644 Mackinac
Roseville, MI 48066

Phone:  (586)777-7542
Cell:      (248)789-8493
e-mail:  dlangschied@ameritech.net


Re: Logical Fields in postgres.

From
Rajesh Kumar Mallah
Date:

Did you mean boolean feilds similar to Yes/No feilds of MS ACCESS?

regds
mallah.

On Tuesday 29 Apr 2003 2:05 am, dlangschied wrote:
> 'Lo all,
> How do I create a logical field in postgres?  These fields were not
> recognized when I tried to load them.
>
> Sincerely,
>
> David Langschied
> Langschied Consulting Services
> 25644 Mackinac
> Roseville, MI 48066
>
> Phone:  (586)777-7542
> Cell:      (248)789-8493
> e-mail:  dlangschied@ameritech.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.


Re: Logical Fields in postgres.

From
"dlangschied"
Date:
Yes, I did figure this one out.  Boolean is the correct conversion.  I have
another question:  I have a database that supports arrays.  I do not see
arrays listed under data type or in any of the documentation.  Is there
support for arrays in postgres?  If not, I soppose I will have to create new
fields for each array position.  Any help would be greatly appreciated.



Sincerely,

David Langschied
Langschied Consulting Services
25644 Mackinac
Roseville, MI 48066

Phone:  (586)777-7542
Cell:      (248)789-8493
e-mail:  dlangschied@ameritech.net
----- Original Message -----
From: "Rajesh Kumar Mallah" <mallah@trade-india.com>
To: "dlangschied" <dlangschied@Ameritech.Net>; <pgsql-admin@postgresql.org>
Sent: Tuesday, April 29, 2003 7:28 AM
Subject: Re: [ADMIN] Logical Fields in postgres.


>
>
> Did you mean boolean feilds similar to Yes/No feilds of MS ACCESS?
>
> regds
> mallah.
>
> On Tuesday 29 Apr 2003 2:05 am, dlangschied wrote:
> > 'Lo all,
> > How do I create a logical field in postgres?  These fields were not
> > recognized when I tried to load them.
> >
> > Sincerely,
> >
> > David Langschied
> > Langschied Consulting Services
> > 25644 Mackinac
> > Roseville, MI 48066
> >
> > Phone:  (586)777-7542
> > Cell:      (248)789-8493
> > e-mail:  dlangschied@ameritech.net
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> --
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.


Re: Logical Fields in postgres.

From
Tom Lane
Date:
"dlangschied" <dlangschied@ameritech.net> writes:
> Yes, I did figure this one out.  Boolean is the correct conversion.  I have
> another question:  I have a database that supports arrays.  I do not see
> arrays listed under data type or in any of the documentation.

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/arrays.html

            regards, tom lane


Re: Logical Fields in postgres.

From
Oleg Bartunov
Date:
On Tue, 29 Apr 2003, Tom Lane wrote:

> "dlangschied" <dlangschied@ameritech.net> writes:
> > Yes, I did figure this one out.  Boolean is the correct conversion.  I have
> > another question:  I have a database that supports arrays.  I do not see
> > arrays listed under data type or in any of the documentation.
>
> http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/arrays.html

Also, you might consider contrib/intarray for index support.

>
>             regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Re: Logical Fields in postgres.

From
"dlangschied"
Date:
Thanks!  I did not see it in the outline, but I did already have this file.
Sincerely,

David Langschied
Langschied Consulting Services
25644 Mackinac
Roseville, MI 48066

Phone:  (586)777-7542
Cell:      (248)789-8493
e-mail:  dlangschied@ameritech.net
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "dlangschied" <dlangschied@Ameritech.Net>
Cc: "Rajesh Kumar Mallah" <mallah@trade-india.com>;
<pgsql-admin@postgresql.org>
Sent: Tuesday, April 29, 2003 10:41 AM
Subject: Re: [ADMIN] Logical Fields in postgres.


> "dlangschied" <dlangschied@ameritech.net> writes:
> > Yes, I did figure this one out.  Boolean is the correct conversion.  I
have
> > another question:  I have a database that supports arrays.  I do not see
> > arrays listed under data type or in any of the documentation.
>
> http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/arrays.html
>
> regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org