-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I need to write a function which has to replace a character with two or three other
> characters
>
You can use the replace function as specified below:
replace(string text, from text, to text) text
Replace all occurrences in @string of substr
--- Freddy Villalba Arias
<[EMAIL PROTECTED]> escribió: > Hello
everybody,
>
>
>
> I'm not sure if this is a bug on the upper/lower
> command or anywhere else.
>
>
>
> This is the problem:
>
>
>
>
>
> I have a DB that uses 'UNICODE' encoding. PostgreSQL
> version is 7.4.2.
>
>
>
Hi,
I need to write a function which has to replace a
character with two or three other characters
I have some data in the DB and when I retrieve this
data, I have sorting problems because I use specific Croatian characters
I know that the DB is not setup properly, but I
cannot
PS PS wrote:
SQL Guru's,
Does anyone know what is the Column Limit in a SQL
Query in Oracle RDB version 7.1?
I've about 200 columns in my SQL query. Each column
is a computed column -- Case when a = b Then c Else 0
End.
You'll probably want an Oracle mailing list - this is for PostgreSQL.
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There are two ways to do it. The server-side approach is to increase
logging levels in the config file and then "pg_ctl reload". See
http://www.postgresql.org/docs/7.4/interactive/runtime-config.html#RUNTIME-CONFIG-LOGGING
for the stuff involved.
The ot
> > or Can i have varchar types of size 50 as primary keys in Postgres.
> Yes. But unless the 50 character limit comes from a business rule, you
> might want to use the type 'text'.
And if that limit does come from a business rule you might want
to think twice whether using columns constrained by
SQL Guru's,
Does anyone know what is the Column Limit in a SQL
Query in Oracle RDB version 7.1?
I've about 200 columns in my SQL query. Each column
is a computed column -- Case when a = b Then c Else 0
End.
It gives me a runtime error -- abnormal program
termination -- upon execution.
Than
On Mon, 17 May 2004, Stijn Vanroye wrote:
> Are you sure about that Edmund?
>
> I have the following query:
> select distinct on (task_id, date) task_id, workhour_id, date from
> (
> select task_id, workhour_id, begindate as date from workhour
> UNION
> select task_id, w
On Tue, Feb 10, 2004 at 12:03:36 -0500,
[EMAIL PROTECTED] wrote:
> Hi all i am using postgres and torque
> I have a column x in Table A of type varchar and NOT NULL. I want to
> impose a unique key constraint on that table and column y is the primary
> key.
> I have another Table B with column x.
First of all, I don't select distinct on 1 value, but on 2. Meaning I want each unique
combination of task_id (or employee_id in this example) and date. That way both fields
still have meaning.
the workhour_id field is indeed redundant, but was still there from some pevious
testing work. (It is
Hello everybody,
I’m not sure if this is a bug on the upper/lower
command or anywhere else.
This is the problem:
I have a DB that uses ‘UNICODE’ encoding.
PostgreSQL version is 7.4.2.
I have a field that holds characters, including characters
like ‘Ñ’ (lowercase versio
> I forgot one situation:
>
> if I run the query like so:
> select distinct on (task_id, begindate) task_id, workhour_id,
> begindate as date from workhour UNION
> select distinct on (task_id, enddate) task_id, workhour_id, enddate
> as date from workhour I get yet another value: 2961 r
Are you sure about that Edmund?
I have the following query:
select distinct on (task_id, date) task_id, workhour_id, date from
(
select task_id, workhour_id, begindate as date from workhour
UNION
select task_id, workhour_id, enddate as date from workhour
)as dist1
whi
Sorry,
I forgot one situation:
if I run the query like so:
select distinct on (task_id, begindate) task_id, workhour_id, begindate as date
from workhour
UNION
select distinct on (task_id, enddate) task_id, workhour_id, enddate as date from
workhour
I get yet another value: 29
14 matches
Mail list logo
