Hi admins,
I got a conceptual question on creating a stored procedure
I need for my app. First the description of the problem:
I need a counter which works with 36 possible values per
character [0-9 and thereafter A-Z].
That means if incremented it should return values as follows:
Hi all,
I am quite new in Postgresql and I am wondering if it supports data
replication.
If I understand correctly postgresql has only the pg_dumpall function
that makes a copy/backup of the database, and it does not support a
functionality for automatic data replcation in a backup database
On Tue, Apr 20, 2004 at 11:08:12AM +0300, GP wrote:
Hi all,
I am quite new in Postgresql and I am wondering if it supports data
replication.
Yes. There are several projects supporting it, some in contrib/ and
some on the gborg.postgresql.org site. My employer, Afilias uses
erserver today,
Hello Enrico,
You could try this.
create table codes (code_urn integer, code char(1));
create sequence code_urn_seq minvalue 0 maxvalue 35 cycle;
insert into codes values(0,'0');
...
insert into codes values(35,'Z');
Then the following query would give you the incrementing code
Hi Paul,
PB select code from codes where code_urn = (select nextval('code_urn_seq'));
Yes this is a great idea, but it only manages
one character. But I need a counter with
at least a variable length and it has to be
filled with leading zero-values, so that
the length of the generated counter
hi,
Dion Almaer wrote, On 4/19/2004 21:44:
- ERROR: invalid byte sequence for encoding UNICODE: 0xe9616c
and for this: convert your dump with iconv to unicode, then load it.
C.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
For unknown reasons, our PG server died overnight. (PG 7.4.2, RedHat 8,
ext3 ordered data mode, and battery backed RAID5) When it came back up, I
saw an unfamiliar line in the recovery output from Postgres:
Apr 20 11:28:14 postgres: [6203] LOG: database system was interrupted at
2004-04-20
I have just migrated from 7.2.1 to 7.4.2 and I have the following tables
defined in my database.
/* */
/* Table: vm_config */
/* */
create table vm_config
(
Parameter
Please unsubscribe me from this list.
---(end of broadcast)---
TIP 8: explain analyze is your friend
_
Watch LIVE baseball games on your computer with MLB.TV, included with MSN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
(1679616 is 36^4, 36 is 0-9+A-Z)
CREATE SEQUENCE abase MINVALUE 0 MAXVALUE 1679616 CYCLE;
CREATE OR REPLACE FUNCTION fillbase(BIGINT,INT,INT) RETURNS VARCHAR AS '
DECLARE
mynumINTEGER;
mybase ALIAS FOR $2;
myplaces SMALLINT;
first
10 matches
Mail list logo
