Noodle wrote:
>
> I cannot believe that PostgreSQL has a so poor document, I cannot found any
> useful information. I afraid I have to select MySQL.
>
> Does anybody know if PostgreSQL support Unicode and Full-Text Index? I
> couldn't found any information about these from http://www.postgresql.
Please could a kind soul help me with this.
I can't find _any_ - however cryptic - docs about plpgsql.
create function nice_date(date) returns varchar as '
declare
t alias for $1;
d text;
m text;
y text;
begin
day := rtrim(to_char(\'t\'::timestamp, \'Day\'));
month := rtrim(to_char(\'t\
Hello there
Is it possible to move a record from one table to another to do a archive
with a simple command like move ?
Thanks jr
PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland
phone: +
From: "Christopher Sawtell" <[EMAIL PROTECTED]>
> Please could a kind soul help me with this.
> I can't find _any_ - however cryptic - docs about plpgsql.
You need to look in the User's guide Chapter 9 (in the pre-release docs
anyway)
> create function nice_date(date) returns varchar as '
> de
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 13, 2001 12:45 PM
Subject: [SQL] copy a record from one table to another (archive)
> Hello there
>
> Is it possible to move a record from one table to another to do a archive
> with a simple co
On Tuesday, 13. March 2001 12:53, Christopher Sawtell wrote:
> Please could a kind soul help me with this.
> I can't find _any_ - however cryptic - docs about plpgsql.
Click here:
http://www.postgresql.org/devel-corner/docs/programmer/plpgsql.html
> create function nice_date(date) returns varcha
Hello,
do you happen to know, if there is any sqlserver that WON'T handle
inserting default value if it is not specified in the INSERT field list? I
am particularly interested in ORACLE, INFORMIX and MYSQL .
Eg.
CREATE TABLE test
(
id integer default 5,
fld1 text
);
INSERT INTO test (fld1)
Is there a win32 version for psql?
JACK
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Hi All,
I haven't posted a silly question in a while, and didn't want to break my
streak...
I have a table like this:
id | make | model | year | value
-+---++---+---
57 |2 |0 | 4 | 4750
57 |2 |
Hi All,
I haven't posted a silly question in a while, and didn't want to break my
streak...
I have a table like this:
id | make | model | year | value
-+---++---+---
57 |2 |0 | 4 | 4750
57 |2 |
Patrik Kudo <[EMAIL PROTECTED]> writes:
> I've for a while now been using the != operator in my sql queries, but in
> almost all examples I see <> instead. Are there any good reason to use
> any instead of the other? I prefer !=, but if you convince me, I'll change to
> what you other guys are usi
On Mon, Mar 12, 2001 at 09:21:58PM -0500, Tom Lane wrote:
> Spy <[EMAIL PROTECTED]> writes:
> > Tom Lane a écrit :
> >> Is that actually how MySQL interprets two parameters? We treat them
> >> as count and offset respectively, which definition I thought was the
> >> same as MySQL's.
>
> > But My
How many of the other dbms' out there have this "hardwired hack"? Is
something that's postgres-specific, or is it found in oracle and sqlserver
too?
Regards,
Patrik Kudo
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!
On Tue, 13 Mar 2001, Tom Lane
On Fri, Mar 09, 2001 at 11:05:38AM -0800, Alder wrote:
> I'm pretty new to SQL and can't figure out how to write what should be a
> simple query of two tables. Could someone here possibly help me out?
>
> Table 1 has two fields I'm interested in: TITLE_NO and EFFECT_DATE
> Table 2 also has two f
Thanks for your help.
It runs blindlingly fast under beta5 so I'll keep my fingers crossed and
hope it will be stable enough!
Tom Lane wrote in message <[EMAIL PROTECTED]>...
>"david morgan" <[EMAIL PROTECTED]> writes:
>> I am having a few problems using a select query which joins two views
>
Ken Corey writes:
> It sounds easiest to me to just punt and number the rows as they are returned
> in my calling application...
The rows are automatically numbered. In libpq, you'd use
PQgetvalue(result, rownumber, fieldnumber). Other interfaces have similar
functions. If the interface has a
On Wed, 14 Mar 2001 01:38, Richard Huxton wrote:
> From: "Christopher Sawtell" <[EMAIL PROTECTED]>
>
> > Please could a kind soul help me with this.
[ ... ]
> Note to readers: this is not a general service, I'm in a good mood ;-)
In that case, thank you very much indeed, and may the blessings
17 matches
Mail list logo
