Hello Leo,
which version of PostgreSQL are you running? I tested:
select to_char(abm_dat, 'DD/MM/') AS new_date
from t_dummy;
And it works fine:
new_date
31/03/1992
15/06/1994
11/09/1993
19/11/1993
...
Regards, Jens
Leo Xavier schrieb:
> [...]
> doing this:
> SELECT
Brett Schwarz <[EMAIL PROTECTED]> writes:
> However, when I look at the programmers guide (Ch. 4), it almost leads me to
> believe otherwise:
> The following more interesting example takes a single argument of type EMP,
> and retrieves multiple results:
> select function hobbies (EMP) returns se
Hello
first time I post something... good morning everyone!
short presentation: Leo Xavier, Lisbon - Portugal, 17 years, my home-made
site: www.megabenfica.com
Sql7, win 2000...
The question:
How for example do I select all entrys from a certain month (of a certain
year, of course) ?
Or from a ce
[EMAIL PROTECTED] writes:
> I'm building a script to create the tables in my database. Everything
> works fine except one thing with this part of my script:
> create table tbl_resume_free_text_type (
> type_id int,
> type text
> );
> -- insert into tbl_resume_free_text_type
Peeter Smitt wrote:
> Hi
>
> I'm trying to make updateable view useing rules.
>
> CREATE RULE update_rule AS ON UPDATE TO table DO INSTEAD
> SELECT fun1(new);
>
> Thing is that backend gives this error.
> ERROR: parser: parse error at or near ")"
>
> What i'm doing wrong? Are there any other
Hi,
I'm building a script to create the tables in my database. Everything
works fine except one thing with this part of my script:
create table tbl_resume_free_text_type (
type_id int,
type text
);
-- insert into tbl_resume_free_text_type (type_id, type) values (1, 'Hobbies');
On Tue, 2 Jan 2001, Diehl, Jeffrey wrote:
> Hi all.
>
> I'm hoping to migrate from mysql to postgresql but need some of the features
> in 7.5. Any idea when it will be out?
well, we have to get through 7.1, 7.2, 7.3 and 7.4 first ... at a 6mo
turnaround on each release, sometime in '03? :)
ser
I assume you mean 7.1. We are in beta now. That usually takes a month.
[ Charset ISO-8859-1 unsupported, converting... ]
> Hi all.
>
> I'm hoping to migrate from mysql to postgresql but need some of the features
> in 7.5. Any idea when it will be out?
>
> Thanx,
> Mike Diehl.
>
>
--
B
Hi all.
I'm hoping to migrate from mysql to postgresql but need some of the features
in 7.5. Any idea when it will be out?
Thanx,
Mike Diehl.
I have seen in the postings that it is not possible to return multiple rows
from a function.
However, when I look at the programmers guide (Ch. 4), it almost leads me to
believe otherwise:
-8<---
The following more interesting e
Hi,
I have created a table songs as follwoing:
CREATE TABLE songs (
song_id serial NOT NULL,
title character varying(50) NOT NULL,
composer varchar(50),
performer varchar(50),
artist_id int4 not null,
file_size int4,
description text,
extrInfo t
I just recieved SQL in a Nutshell from O'Reilly. I bought the book
because it covers the SQL99 standard. It's my understanding that this
is the most recent SQL standard. Am I correct about this? What is the
current status of SQL standards? What is the most recent approved
standard, and what a
Thomas SMETS writes:
>
> ISBN's have a checkdigit; it would be sensible to provide a
> function to be used in a CHECK constraint to ensure that the
> ISBN is valid.
>
>
> OK I'll start searching for it but haven't implemented yet
In the PostgreSQL distribution there's a directory contrib/isbn_
Thomas SMETS wrote:
>
>
> ISBN's have a checkdigit; it would be sensible to provide a
> function to be used in a CHECK constraint to ensure that the
> ISBN is valid.
>
Here's a URL with more
information:http://www.isbn.spk-berlin.de/html/userman/usm4.htm.
I've written a similar algorithm in
Hello Francis,
Tuesday, January 02, 2001, 3:23:49 AM, you wrote:
FS> Hi Boris,
FS> I know Kaare Rasmussen posted a URL to the online documentation already,
FS> but this might be a direct solution to your problem:
FS> DELETE FROM onlineuser WHERE datum < ('now'::datetime - '5
FS> minutes'::inte
Hi Boris,
I know Kaare Rasmussen posted a URL to the online documentation already,
but this might be a direct solution to your problem:
DELETE FROM onlineuser WHERE datum < ('now'::datetime - '5
minutes'::interval);
Hope this helps
Francis Solomon
> Hello
>
> I am moving from MySQL to Postgre
Ferruccio Zamuner <[EMAIL PROTECTED]> writes:
> expire date default 'infinity');
> ERROR: Unrecognized date external representation 'infinity'
infinity is a timestamp (or datetime) feature, not a date feature.
regards, tom lane
17 matches
Mail list logo
