Re: [GENERAL] Graphics Supported?

1999-01-14 Thread Tim Williams
> Is it possible to store a gif or jpg image > in a PG database, then retrieve the image > and display it on a web page? > > If so, how do you create the table? > > -Thanks To propose something horribly simple and direct, perhaps it would make more sense to actually just store the files on disk

[GENERAL] Error

1999-01-14 Thread Kaare Rasmussen
I got an error when accessing a view. The view looks like this: CREATE TABLE ar_contacts( contact_seq int, update_date date, period date, paidfloat, sales float, last_date date, due fl

RE: [GENERAL] non-case sensitive searches

1999-01-14 Thread Jackson, DeJuan
> On Wed, 13 Jan 1999, Jackson, DeJuan wrote: > > > And remember unless you use full text indexing (which is > expensive) you > > won't have indexing on that search (for either the LIKE or regex). > > -DEJ > > Actually, if you use case sensitive regex, and anchor the > begining (with > ^)

RE: [GENERAL] non-case sensitive searches

1999-01-14 Thread Gregory Maxwell
On Wed, 13 Jan 1999, Jackson, DeJuan wrote: > And remember unless you use full text indexing (which is expensive) you > won't have indexing on that search (for either the LIKE or regex). > -DEJ Actually, if you use case sensitive regex, and anchor the begining (with ^) then it will use btr

Re: [GENERAL] 'Pg' is what we called DBI?

1999-01-14 Thread Sergei M. Suntsov
> Hi, > > I want to use Perl with DBI(DataBase Independent Interface) to write cgi > scripts. > In /src/interfaces/perl5 directory, I found Pg. But my friend told me that Pg > isn't DBI. Now I'm confused. Pg is DBI or not? > If not, how can I install Postgres DBI? > > -Kevin. Go to CPAN mirror n

[GENERAL] 'Pg' is what we called DBI?

1999-01-14 Thread Kevin Lo
Hi, I want to use Perl with DBI(DataBase Independent Interface) to write cgi scripts. In /src/interfaces/perl5 directory, I found Pg. But my friend told me that Pg isn't DBI. Now I'm confused. Pg is DBI or not? If not, how can I install Postgres DBI? -Kevin.

[GENERAL] How to display stored image on web page?

1999-01-14 Thread Bernie
Now that I've stored several jpg's in my database as large objects, I'm trying to display them on a web page using a java servlet. Im my servlet, I've changed the content type to image/jpeg - response.setContentType("image/jpg"); When the web page is loaded, all I see is the ID number of the imag