Re: another stupid question

From: "Jeff Duffy" <jeff(at)alanne(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: another stupid question
Date: 2001-04-03 19:56:43
Message-ID: 200104040058.f340w0827527@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)alanne(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2001-04-03 19:59:07 Re: dev version changes/release history
Previous Message Sean Harding 2001-04-03 19:33:34 dev version changes/release history