Re: Logical Fields in postgres.

'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(at)ameritech(dot)net

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(at)ameritech(dot)net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)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.

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(at)ameritech(dot)net
----- Original Message -----
From: "Rajesh Kumar Mallah" <mallah(at)trade-india(dot)com>
To: "dlangschied" <dlangschied(at)Ameritech(dot)Net>; <pgsql-admin(at)postgresql(dot)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(at)ameritech(dot)net
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)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.

"dlangschied" <dlangschied(at)ameritech(dot)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

On Tue, 29 Apr 2003, Tom Lane wrote:

> "dlangschied" <dlangschied(at)ameritech(dot)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(at)postgresql(dot)org
>

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

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(at)ameritech(dot)net
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "dlangschied" <dlangschied(at)Ameritech(dot)Net>
Cc: "Rajesh Kumar Mallah" <mallah(at)trade-india(dot)com>;
<pgsql-admin(at)postgresql(dot)org>
Sent: Tuesday, April 29, 2003 10:41 AM
Subject: Re: [ADMIN] Logical Fields in postgres.

> "dlangschied" <dlangschied(at)ameritech(dot)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(at)postgresql(dot)org