From: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
---|---|
To: | Franck Martin <Franck(at)sopac(dot)org> |
Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jeffrey A(dot) Rhines" <jrhines(at)email(dot)com>, PostgreSQL:"(at)connect(dot)com(dot)au:General List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [Solved] SQL Server to PostgreSQL |
Date: | 2000-08-23 11:38:05 |
Message-ID: | 39A3B79D.400546CA@cupid.suninternet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Franck Martin wrote:
>
> As we are talking about 7.1 and huge field size...
>
> MS-SQL has a function that allows you to retreive part of a field a kind of
> mid$(field, start, length). This would be a good addition indeed.
does substr() not handle this?
> last problem. PG does not allow to store binary data. I'm not talking about
> the current implementation of BLOB, but what will happen in 7.1...
>
> If I want to store an image in a field. I cannot do that in 7.1 because the
> data sent by 7.1 and received in libpq must be formated in ASCII. I haven't
> play around to see if I could create a user type called varbinary(n), which
> will output via varbinary_out just the content of a buffer... May be varchar
> does it already (even if there is a \0?).
One thing I've thought about is creating an escape char to delimit this
sort
of thing. Maybe a control-A, followed by four bytes giving the length
followed
by that many byes of data. Escape \0's with ^A0 and a real ^A with ^A^A.
I would love something like this because I always get tripped up by
fields
I'm inserting containing quotes and other characters that need to be
escaped.
> I know I should submit this problem to the hacker list, but I don't want to
> subscribe to hacker just to submit one message...
Heh, I know what you mean...
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/
From | Date | Subject | |
---|---|---|---|
Next Message | jeff seaman | 2000-08-23 11:43:43 | windows supported platforms |
Previous Message | Darrin Ladd | 2000-08-23 11:35:08 | pg_class not updated correctly? |