Hi,
Something like this?
SELECT date_part('day',
(date_part('year', '01/10/04' :: date) || '-' ||
date_part('month', '01/10/04' :: date) || '-01') ::date
+ '1 month'::interval
- '1 day'::interval) AS days;
Regards,
Arthur
On Wed, 30 Mar 200
Hi,
The company I work for actually uses the Zeos lib/Postgres extensively
to track the shipping and sales side for almost 3 years.
We're still running on a 7.2/7.4 Postgres database, because I haven't
been convinced yet to either update or upgrade to 8.x.x. I'm curious
if others have successfull
Hi,
Phishing scam for sure. I thought it was hilarious in a way: "Why
would the host of postgresql.org send himself a bill?".
Kind of a silly paradox.
Regards,
Arthur
On 6/8/05, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> Matt Miller wrote:
> >>you will have to confirm your account by the f
Hi,
If I'm not wrong, Postgres comes with a BSD license, which means that
it (literally) doesn't matter what you do with the sources or how you
link your applications to the Postgres libraries. Pervasive goes into
details here: http://www.pervasivepostgres.com/postgresql/mysql.asp.
Regards,
Ar
Hi,
>You can close source it, you can sell it, you can rename it.
Add to that: As long as you leave the copyrights notices alone...
Isn't that what the BSD license is particularly about? [but then, I
might be wrong there]
Regards,
Arthur
---(end of broadcast)-
Hi,
Pretty neat: I'm glad I'm not on that map!
Regards,
Arthur
On 10/24/05, Claire McLister <[EMAIL PROTECTED]> wrote:
> Hi,
>
> We've developed an automatic email mapping capability from Google Maps
> API.
>
> To try it out, we mapped origins of emails to this group from October
> 2, 20
Hi:
There are a couple of solutions to solve this problem and some of them
will depend on how frequent you expect these changes to happen.
I generally stay clear from server-specific notifications: In the
larger projects I have seen and maintained, we used background
processes to do this kind of
Hi:
What's the point of declaring the TEdit locally? Use a string
instead. Additionally, in Delphi [and any other OOP language) if you
want to use objects, you instantiate them first, as in Edit1 :=
TEdit.Create(nil);
Regards,
Arthur
On 4/13/07, Bob Pawley <[EMAIL PROTECTED]> wrote:
I
Hi,
You may find something here: http://www.rot13.org/~dpavlin/sql.html.
In addition, I always thought that Postgres came with a MySQL to
Postgres converter, but I might be wrong.
Bye,
Arthur
On Wed, 08 Sep 2004 11:07:46 -0400, Eric <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a running PHPBB
Hi,
If you're using 7.4 or below (I'm not sure if 7.5 is able to do this),
you'll end up writing the data first to a temporary table, as in (for
example):
SELECT * INTO TEMPORARY MyTable
FROM yourtable;
DROP TABLE yourtable;
CREATE TABLE yourtable (
/* with varchar stuff */
) WITH OIDS;
IN
10 matches
Mail list logo