On Sat, 24 Mar 2001, Mohamed ebrahim wrote:
> I am a user of postgresql. I want to know that it
> is possible to call a jsp file in postgre
> command.Please help me to know how to call a jsp file.
What do you mean 'call a JSP file'? A JSP file is parsed and compiled by
something like Jasper
On Tue, 6 Mar 2001, Josh Berkus wrote:
> Just a quick question ... I need to do a regular transfer (daily + on
> demand) of data from a MySQL database to a PostgreSQL database and back
> again. Can anybody steer me towards a good script for this, or do I
> have to write my own in PHP?
Don
On Sat, 10 Feb 2001, Najm Hashmi wrote:
> How can I concatnate two varialbles, seperated by a |, that are type text
> together?
> v, v1 text;
> some work
> then
> res:= v ||''|''|| v1;
What error is it giving? Do you need to be using two single quotes in the
statement?
-- Brett
On Wed, 7 Feb 2001, Brice Ruth wrote:
> Is there a simple (unix) command I can run on text files to convert
> cr/lf to lf? The way I did it seemed pretty ass-backward to me (not to
> mention time consuming).
perl -pi -e 's/\cM\\g'
will do the trick, assuming you have Perl instaleld on your sy
On Mon, 5 Feb 2001, Sebastian --[ www.flashhilfe.de ]-- wrote:
> I have make a search machine whit:
>
> LIKE '%$suchbegriffe[$i]%'
>
> but when I search Test - the search machine shows only entries
> whit Test. But not test or tESt.
LIKE is case-sensitive. You should convert your column to uppe
On Thu, 25 Jan 2001, wrote:
> I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but
> its not working. can someone show me a example or something?
Wildcards where? You can use * to mean all the fields in a table in a
SELECT statement, but if you are using LIKE in a WHERE c
On Sat, 27 Jan 2001, Glen and Rosanne Eustace wrote:
> Is 7.0.3 to 7.1B? simply a reinstall or do I need to unload/reload the
> database.
Yep, you need to do whole shebang of dumping and reloading.
-- Brett
http://www.chapelperilous.net/~bmccoy/
On Sat, 27 Jan 2001, Glen and Rosanne Eustace wrote:
> If some one else is running 7.1 already and can just change their
> timezone to New Zealand DT and report the results it would be great.
Here ya are:
cp=> set time zone 'NZ';
SET VARIABLE
cp=> select '12/31/2000'::date + '1 year'::interval
On Thu, 25 Jan 2001, Markus Wagner wrote:
> I have some data that I wish to transfer into a database using perl/DBI.
> Some of the data are strings containing the apostrophe "'" which I use
> as string delimiter.
>
> How can I put these into my database using the INSERT statement?
You will need
On Thu, 25 Jan 2001, Glen and Rosanne Eustace wrote:
> pressie# select '31/12/2000'::date + '1 year'::timespan;
> ?column?
> -
> 01/01/2002 00:00:00.00 NZDT
> (1 row)
>
> pressie=#
>
> Well I do :-(
>
> I vaguely remember someone else having the same problem
On Sat, 20 Jan 2001, Tom Lane wrote:
> None, I fear. The stuff you are fooling with is leftover from the old
> PostQuel language. Most of it is suffering from bit rot, because the
> developers' focus has been on SQL92 compliance for the last six or seven
> years. I hadn't realized that SQL99 h
On Thu, 18 Jan 2001, Poet/Joshua Drake wrote:
> >it seems that the author never used any other think then PHP ...
>
> I am afraid I would disagree. I have used all of the languages he metions
> and for the Web, PHP is the best.
I think it all depends on what you are building. PHP is good for sm
On Thu, 18 Jan 2001, Michael Richards wrote:
> As I understand Zend is a compiler/interpreter that uses a optimised
> bytecode to run a little faster than the normal apache/php. It shares
> few of the features of perl, even fewer of Java. C++? Last time I
> checked, PHP couldn't do OOP. Next thin
On Thu, 18 Jan 2001, Kaare Rasmussen wrote:
> > I do not see how it puts the Postgres community in a bad light, although I
> > do see how the author is a moron.
>
> People think that it's an official PostgreSQL document. It turned up in a
> discussion (PostgreSQL vs. MySQL round 1000) as "the Pos
On Tue, 2 Jan 2001, Macky wrote:
> Is there a function in SQL that does autoincrementing...
http://www.postgresql.org/docs/faq-english.html#4.16.1
and
http://www.postgresql.org/users-lounge/docs/7.0/postgres/sql-createsequence.htm
will tell you how to do this.
-- Brett
On Sat, 30 Dec 2000, Thomas SMETS wrote:
> If i create a "internal pk" buy defining on a table a field SERIAL.
> How do I reference this field in the other table to set the field
> possible value ?
>
>
> create table book (
> /* This is an internal primary key for the book description */
>
On Sun, 24 Dec 2000, Thomas SMETS wrote:
> I'm runnin postgres 7.?? (Last RPM package available from the site).
>
> I want to create a few DB creation scripts so I can "publish" that
> afterwards.
> On Oracle there's a such possibility but I haven't seen anything
> comaprable in the docs ...
> I
On Tue, 19 Dec 2000, Bruno Boettcher wrote:
> actually i look up if the corresponding entry exists (comparing
> user-name and field-name) if yes i update, if no i insert
>
> this isn't very appealing, but i couldn't find another way yet to make
> this shorter...
>
> would be nice if something
On Fri, 15 Dec 2000, vs wrote:
> Hope my message doesn't bother you.
> I want to use readline with pgsql7.02 on mandrake 7.2.
> LM7.2 installed both packages, readline/devel & postgres.
> How to make psql know about readline?
If you are using a binary installation of Postgres (you installed via
On 13 Dec 2000, Marc Daoust wrote:
> I in the search for a DB that would work with our product and have been told
> to have a look at postgres. Would you be able to foward me any information on
> your product and or point me to where I might be able to find some.
You should start with www.postg
ll script is necessary. So, is it possible to
> call 'psql' and returning its query result and I can use sendmail to
> email the result? Any other idea?
Is there any reason to not use Perl & DBI or the Pg.pm module?
Brett W. McCoy
http:
elational angle of view,
> the system will do well.
I was going to say that, but assumed it would be obvious. :-)
Brett W. McCoy
http://www.
th a count of
items in each order, and so forth, all in SQL.
Brett W. McCoy
http://www.chapelperilous.net
---
Virtue does not always demand a heavy sacrific
On Tue, 6 Jun 2000 [EMAIL PROTECTED] wrote:
> Hello! wers regarding a book proposal on
>
> Regarding the book proposal on Postgres: I can tell you that the world
> needs a Postgres book!
Bruce Momjian has almost completed his, and you can see it on the main
PostgreSQL website.
Br
24 matches
Mail list logo
