[GENERAL] National Number to text conversion

2006-05-29 Thread Samer Abukhait
Hello,is there any known way to convert numbers to their text equivalent in English and other languages?like 25 -- Twenty FiveI am interested in Arabic specifically.

Re: [GENERAL] National Number to text conversion

2006-05-29 Thread Samer Abukhait
: Make a table that you can reference. Fill it with Arabic, English or any language that you wish. Make it available to the list so those who wish can particpate and receive a copy of the finished product. Bob - Original Message - From: Samer Abukhait To: pgsql-general

Re: [GENERAL] Add column and specify the column position in a table

2006-05-17 Thread Samer Abukhait
the position doesn't really matter in any relational structure.. does it? On 5/17/06, Emi Lu [EMAIL PROTECTED] wrote: Hello, I am trying to insert one column to a specific position in a table. In mysql, I can do: . create table test(id varchar(3), name varchar(12)); . alter table test add

Re: [GENERAL] IF EXISTS

2005-11-14 Thread Samer Abukhait
How about if exists (select .. from ..) On 11/14/05, Jaime Casanova [EMAIL PROTECTED] wrote: On 11/14/05, P.M [EMAIL PROTECTED] wrote: Hi, I would like to know if IF EXISTS exists under postgresql ? because i did not find it. before to create users or database, i would like to be

Re: [GENERAL] Duplicate rows

2005-11-14 Thread Samer Abukhait
so what's the problem exactly?? what's holding you from adding the primary key over fluid_id ?? in the trigger, you could use an if exists to check if the row is there before and i guess there is no need for a loop? you can do the same per row. On 11/12/05, Bob Pawley [EMAIL PROTECTED] wrote:

Re: [GENERAL] Executing Dynamic DDL

2005-05-19 Thread Samer Abukhait
That was very helpful, many thanks About timestamp, I understood that as long as the DB server is the one to log times it is safe to use it without timezones?? (I am not using any of the different timezoned clients??) am i missing the point? about all_table_columns, it is just a simple view to

[GENERAL] Executing Dynamic DDL

2005-05-18 Thread Samer Abukhait
i am trying to execute an 'alter table' statement dynamically.. it seems that execute only works with DML.. is there any way to execute DDL statements?? here is what i am trying to do: create or replace function em.process_table ( p_table varchar) returns

[GENERAL] function bit(integer)

2005-05-15 Thread Samer Abukhait
whats the story of the function bit? was it out there some previous versions and got removed lately?? My 8.0.2 PG hasn't this function, if i found this function any where in previous code, shall i replace it with INT::bit(32) ?? ---(end of

[GENERAL] Named Notation for Functions' Parameteres

2005-05-15 Thread Samer Abukhait
Does PostgreSQL support by anyhow the parameter named notation in function calling?? (like oracle's: parameter_name = argument_value) If not, is it on the wish list? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map