Обсуждение: 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@ameritech.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@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.
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.
"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
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
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