Re: another stupid question
On Wed, 4 Apr 2001 01:43:25 +0200, Alexander Lohse alluded:
Am I missing something about "text" columns?
I seem not to be able to retrieve them (using php) just like varchar
or ... ones.
A simple example:
jeff=# CREATE TABLE test(
jeff(# id INTEGER,
jeff(# stuff TEXT);
CREATE
jeff=# INSERT INTO test VALUES(42, 'Something');
INSERT 64908 1
jeff=# SELECT * FROM test;
id | stuff
----+-----------
42 | Something
(1 row)
I cannot attest for PHP usage: post to the pgsql-php list for that.
btw. I could not find out how much I can put inside a text field!
For version 7.1 there is no longet a limit on the length of field of
type 'text'.
Jeff
--
Jeff Duffy
jeff@alanne.com
Import Notes
Reply to msg id not found: p05010400b6f00fd898eb@192.168.0.144Reference msg id not found: p05010400b6f00fd898eb@192.168.0.144
On Wed, 4 Apr 2001 01:43:25 +0200, Alexander Lohse alluded:
Am I missing something about "text" columns?
I seem not to be able to retrieve them (using php) just like varchar
or ... ones.A simple example:
jeff=# CREATE TABLE test(
jeff(# id INTEGER,
jeff(# stuff TEXT);
CREATEjeff=# INSERT INTO test VALUES(42, 'Something');
INSERT 64908 1jeff=# SELECT * FROM test;
id | stuff
----+-----------
42 | Something
(1 row)
Hi,
that is exactly me!
Then I need to search on different corners for the problem here!
Thank you, anyway!
Regards,
Alex
--
___________________________
Alexander Lohse
Human Touch Medienproduktion GmbH
Am See 1
17440 Klein Jasedow
Tel: (038374) 75211
Fax: (038374) 75223
eMail: al@humantouch.de
http://www.humantouch.de