PostgreSQL Database Forum

Hello! I need get ordered length of the varchcar field in PHP. But pg_FieldLength return -1 (it's right), but I need to get max length for this field. For example, create table t ( str varchar(40) ); I need to get 40...

i just build the rpm for rhel3 based on postgresql-7.4.3-3PGDG.src.rpm but i did not get the postgresql-tcl package. i looked for it in some mirrors like ftp://ftp22.us.postgresql.org/mirrors/www.postgresql.org/binary/v7.4.3/redhat/rhel3/ but apparently it is not included in the RPM version of postgresql 7.4.3 is this true? or it...

Are there any docs that deal with replication and Postgresql? Intro's, faq's, etc. Can anybody recommend a Postgresql replication package? I'm really not familiar with any - seems like there are several, with possibly Slony rising to the forefront. Are there any docs that compare the various options? Would there be any problems...

Hi, why does everyone write CREATE FUNCTION foo() RETURNS INTEGER AS ' blah blah ' LANGUAGE 'plpgsql'; I've never seen for example:

I am trying to figure out if there is a way to determine the timezones supported in postgresql from within the database. If you look at http://www.postgresql.org/docs/7.4/static/datetime-keywords.html it notes that time zone information is system dependent, (I interpret to mean that anything I find in /usr/share/zoneinfo on linux should be...

I wrote the following: CREATE OR REPLACE FUNCTION escritorio.seq_valor_actual( text) RETURNS integer AS ' DECLARE secuencia ALIAS FOR $1; valor_actual integer := 0; v_query text; actual integer; BEGIN RAISE NOTICE ''el parametro tiene el siguiente valor %'' ,secuencia;

Hi all, I'm quite new to postgresql, so please forgive me if these are stupid questions, but I couldn't find answers. I'm using versione 7.3.4 (i can't upgrade, sorry). I've written a trigger function using C to export update query results to a Java program. The trigger seems to work except that it's being called twice for each tuple...

Is there any postgres function that do the following: select func(9123456789); 9 123 456 789 the function is given a number and it returns a "readable" string representation of the number seperating groups of 3 numbers by spaces. Thx

Yes, I vacuumed. Reproduced on both 7.3.2 and 7.5. Brain dead java beans want order by clauses in views that they use. my view is: select .... from bigtable b left join lookuptable l order by bigkey desc;

I have a function that receives a Record or a Rowtype, I need to construct a record of a SQL, to modify a field of the record and soon to pass it to the function but when calling the function is generated an error saying that the variable record is not a column, find examples of call of funciónes that receive record but this call becomes in...

Hi! I've got a query that has a where clause on a timestamp field: select t.board_id , t.thread_id from public.board_thread t where t.last_reply <= now()-'6 months'::interval limit 1

Hi, I thought I read somewhere there was now a native port for Windows for PostgreSQL... Am I wrong? If not, where may I find it to download right away? Thanks, Yannick

Hi We have again experienced data-corruption using 7.4.2 on an XFS Filesystem on top of a software-raid (md) raid-1. After a server crash last night (It was a rather strange crash - The machine was still pingable, but no login was possible, and postgres and apache didn't respond to requests any more) we hard-reset the machine. It came up...

Hello ! I'm in dire need of a compiled libpq.dll with ssl support for win32. I don't know how do complile it myself. (My guess is it requires at least a couple Magic tricks) Thanks a lot /Otto Blomqvist Secom International, Los Angeles CA

I have a int4 coloumn, and I want to change the last bit the the number in this column to 0. How can I do it? Thanks, John

I looked through the docs and contrib, but didn't see anything related to storing and using latitude and longitude values. I have data in the form of 12° 34' N, 12° 34' W. Would any of the geometric data types work well for this type of data? Or just convert them to decimals? Are there any functions for converting lat/long to/from...

I inherited some C code that works as a series of libraries using libpq. One of the libraries has an input to it of a PGresult pointer, but not of a PGconnect pointer. Within the library, the code tries to determine the host name of the connection by doing the following trick: strcpy (host,PQhost(((PGresult*)*pgresult)->xconn)); This...

Hi all, I installed PostgreSQL 7.4.2 from backports.org and all went fine. Then I did as user postgres: create view v_laufverke as select distinct bg.mandant as v_mandant,

To begin with I am not sure this is a correct place to post this, if not please let me know. The PostgreSQL traditionally refuses to run under root account on Unix (for security reasons). On win32 the situation is the same (it will not run if run under user belonging to administrator group). In my opinion this should not be the case on...

I had tomatoes on my eyes. I wrote laufverke but meant laufwerke. Sorry. ---------- Forwarded message ---------- Date: Mon, 12 Jul 2004 15:03:14 +0200 (CEST) From: Holger Marzen <holger@marzen.de> To: pgsql-general@postgresql.org Subject: cannot access or delete view

Hi I am trying to setup a timesheet app. However I have come up against an unexpected problem (possibly fatal) I cannot seem to find a field type in postgres that is equivalent to h:mm without enforcing a 24 hour day limit. This seems to preclude pg from use - am I correct? All the date-time types seem to only be for specific time dates...

Hi All, Can anybody tell from where i can download the latest Postgress Windows version? Thanks, Praveen

Using pl/pgSQL on 7.4.3, I have a varchar column called unit name in a table that can be numeric, of course. Most of the time, end users will put A, B, C, D, etc. or 101, 102, 103, etc. I am trying to write a function to determine the next available number after the first is given. For instance, so far I have a function that will determine 102 is...

Contrary to what the web page suggested: subscribe-digest pgsql-general **** The subscribe command did not succeed. **** **** The command mode "digest" is invalid. The following command **** modes, separated by hyphens ('-') or equals signs ('=') are valid: **** noinform **** nolog

OK, i went to their web site and downloaded some *.tar files...which one do I use to begin the installation? and finish it successfully? tia