"Andrey Y. Mosienko" wrote:
>
> Stephan Szabo wrote:
> >
> > On Tue, 21 Aug 2001, Andrey Y. Mosienko wrote:
> >
> > >
> > > I have table with date type column:
> > >
> > > chdate date;
> > >
> > > SELECT chdate from mytable;
> > >
> > >chdate
> > > 1999-01-02
> > >
> > > But in Russia we hav
Hi,
I try to use odbc on Digital unix platform . I installed iodbc as well
and run the configuration with --enable-odbc option (pgsql v7.1.2),
What shall I do for my driver manager (iodbc in this case), I know that
I should write a .odbc.ini file for configuration, is that all? Because
I have som
> > For example, say I've got a postgresql database of client information
> > (names, addresses, etc.), and I want to use this information to generate
> > envelopes for mailouts. As far as my understanding goes, such
> > functionality is not provided by postgresql itself.
I have the same proble
I have PHP 4.06, PostgreSQL 7.1.2 on sparc-sun-solaris2.7, compiled
by GCC 2.8.1, and Apache on a Solaris server. Most of the time all
works as expected. Occasionally I get an database error:
Database error
There was a database error when accessing Database zwg:
pqReadData() -- backend close
* "Jon Garfunkel" <[EMAIL PROTECTED]> wrote:
| This is similar in functionality to some commerical and opensource O/R
| toolkits I've seen, except that I've created a much more rigorous XML
| framework. In addition, I'm putting much application-level development
| constructs into the XML. I also
and how about this:
SELECT TO_CHAR(chdate, 'DD-MM-')
FROM mytable
ORDER BY chdate::date;
>From: Mike Mascari <[EMAIL PROTECTED]>
>To: "Andrey Y. Mosienko" <[EMAIL PROTECTED]>
>CC: Stephan Szabo <[EMAIL PROTECTED]>, Postgres
><[EMAIL PROTECTED]>
>Subject: Re: [GENERAL] Sort by foreign dat
omid omoomi wrote:
>
> and how about this:
>
> SELECT TO_CHAR(chdate, 'DD-MM-')
> FROM mytable
> ORDER BY chdate::date;
Yes, but Andrey says that the chdate field is declared as a date:
> > > > On Tue, 21 Aug 2001, Andrey Y. Mosienko wrote:
> > > >
> > > > >
> > > > > I have table with dat
"Mark Coffman" <[EMAIL PROTECTED]> writes:
> Yeah, I want autocommit off because there is a perl script that runs between
> the BEGIN and END blocks, and that script uses transactions. I just add the
> $dbh->commit(); to the END block to try to FORCE it to not be idle in
> transaction. I am havi
"Mark Coffman \(Epilogue Programmer\)" <[EMAIL PROTECTED]> writes:
> Thanks for the reply. I use Perl and DBI to make my database conneciton.
> In the
> BEGIN {}
> part of the module, I check for the persistant connection, and make one if
> none is present, autocommit off
> in the
> END {}
> blo
Thanks for the reply. I use Perl and DBI to make my database conneciton.
In the
BEGIN {}
part of the module, I check for the persistant connection, and make one if
none is present, autocommit off
in the
END {}
block, I do a $dbh->commit();
They all still have idle in transaction
:(
- Origi
Hi Carlos,
> For your information, we, brazilians, do not have to fight lions on the
> street or whatever other things you may imagine. Actually, we are doing very
> well as it comes to tecnology. I, for instance, work everyday on a Pentium
> III 1Ghz with 256MB of memory and a 17 inch
At 8/21/01 3:51 PM, Mark Coffman wrote:
>I am having trouble with setting up a scheduled VACUUM. Since VACUUM needs
>an exclusive lock, I can never get it to run. I am using persistant
>connections from a web server and use a single module to make the
>connection. I cannot autocommit because I
I am using numeric(p,s) fields in a database schema.
Using queries that contain a comparison like
...
where numericField = 456.789
will generate an error
Unable to identify an operator '=' for types 'numeric' and 'float8'
You will have to retype this query using an explic
On Tue, Aug 21, 2001 at 07:19:42PM -0400, Tom Lane wrote:
>
> What I suspect is that "autocommit off" causes the DBD driver to send a
> fresh BEGIN immediately after the COMMIT. You might be better off with
> "autocommit on" which I think suppresses any automatic issuance of
> BEGIN/COMMIT. The
Tom Lane wrote:
>
> > On Tue, 21 Aug 2001, Andrey Y. Mosienko wrote:
> > But in Russia we have the next date format: DD-MM-.
>
> Just setting DateStyle to 'SQL' would get you approximately what you
> want:
>
> regression=# set DateStyle TO SQL;
> SET VARIABLE
> regression=# select now();
>
"Andrey Y. Mosienko" <[EMAIL PROTECTED]> writes:
>> If DD/MM/ is not close enough for you, maybe the right answer is to
>> add another DateStyle.
> Sorry for disturbing, but how can I do this or where is it in documentation?
It's not documented; you'd have to dig into the code and see how th
I made some simple functions that create the operators + and - for any
combination of int4's and bool's.
The reasoning that propted this operator was that I wanted to use the
following syntax in a query:
SELECT *,((col_a == 'foo') + (col_b == 'bar')) as relevance WHERE
relevance > 0;
The idea
17 matches
Mail list logo
