Hi The Scripts team,
I would like to ask how oracle handles ordering of japanese characters? I have used order by in my select statement but is not sure if it displays the correct ordering. Thank you in advance..
twinklyblue
Last Activity: Jun 12 '10, 03:34 PM
Joined: Jun 6 '07
Location:
-
ordering of japanese characters in select statements
-
hi pbmods,
thanks for your reply.. however, I am working with Postgres :) I am sure there is a corresponding equivalent for this function.. I can start from this. thanks -
Hi michaelb,
Thanks again for helping! It worked now!Leave a comment:
-
Returning SETOF in plpgsql
Hi thescripts team,
I would like to ask for your help once again regarding returning set of records in plpgsql. I followed examples presented in other sites regarding this function but my script doesnt work.
here's my code
...Code:create or replace function find_postal(varchar, varchar, varchar) returns setof record as ' declare ret_row record; prefnme alias for $1; -
After posting this thread, I found out my answer. (through experiments).
Code:foreach ($rowarray as $row) { for($i=0;$i<count($row);$i++) { echo $row[$i]." "; } }
Whew!Leave a comment:
-
Fetching a row in a array where the column number is unknown
Hi thescripts team,
I am trying to retrive a array and display its contents in the page. However, this array will be dynamic, meaning it will have different sizes in each call (there is a function that will handle the display). My question is, how would I make php read the array where it doesnt need to know the number of columns it has? Any technique that I can implement?
Here's a part of the code that I am currently... -
thanks dafodil, it is what i need. didnt think it would be in the php page.Leave a comment:
-
Implementing encryption in PHP pages
HI thescripts team,
I would like to know if anyone know a good site about SSL in PHP? I already did all the essentials (apache + ssl + mod_ssl installations) but need to test them on a real PHP page. Thanks for your help as always. -
hi michaelb,
Thank you very much!! It worked now. I am so happy to have you here in thescript. You've helped me a lot already. ^^Leave a comment:
-
I'm running on Linux 8.0Leave a comment:
-
array parameter in plpgsql function
Hi team,
I am creating a function that would accept an array of integer as its parameter. I have a table where one of its column is declared as an array. This is an excerpt from the script that I was creating:
...Code:create or replace function insert_busshours(bigint, varchar, integer[]) returns integer as ' begin insert into businesshours values ($1,$2,$3); return ''0''; -
hi michaelb,
thanks for your reply as always. My postgres version is 7.4.1. Do you think this is the version that has this problem?
I followed your suggestion and uploaded the file in batches. First, 100 lines, then I went on on until I got the error when I was uploading about 1000 lines. Then I found that the limit is 600 lines per batch. given this statistics, it is nearly impossible to upload 200k lines by batches...Leave a comment:
-
Hi!
I tried the copy command for the uploading of the data with the following commands used:
then I encountered the following error following the execution of this command:Code:copy area_new from '/var/lib/pgsql/KEN_ALLpk.txt' with delimiter ';';
I am not sure where the error is.. but this is how one of my rows looks...Code:ERROR: invalid memory alloc request size 1073741824
Leave a comment:
-
Hi All,
After a few readings, I found out about the copy command. I tried executing this code but encountered an error.
error msg:Code:copy ken_all from '/var/lib/pgsql/KEN_ALL.CSV';
ERROR: invalid memory alloc request size 1073741824
is there something wrong with my script?Leave a comment:
-
bulk copy from flat file to postgres dbserver
Hi The Scripts team,
I would like to know if there is a same function like bcp (for sybase and mssql 2k) for postgres? Is there any way that I can copy my csv datafile into the postgres database? For anyone who knows, thanks as always. -
HI Mike,
Sorry for the late reply but apparently, I was able to debug my script. Thanks for your help as always!Leave a comment:
-
Hi Mike, The language apparently was installed by someone (i am not sure who but the last time i check it..it was already there) so I tried to recompile the stored proc again. It was successfully recompiled however, there is a runtime error which I cant understand. (postgreSQL's error display is really not that friendly, IMHO).
error:
ERROR: syntax error at or near "$1" at character 16
CONTEXT: PL/pgSQL function...Leave a comment:
-
I fortunately found the reason for my problem. I got the syntax incorrect. It should be
[code=sql]
SELECT * FROM menu OFFSET 0 LIMIT 10
[/code]...Leave a comment:
-
syntax is not supported error
HI team,
I was trying to run the following code and got the below error. Can someone inform me why this is such? I'm using Postgres 7.2. Any workaround to make this script work? Thanks!
[code=sql]
SELECT * FROM menu LIMIT 0, 10
[/code]
error:
LIMIT #,# syntax is not supported -
[CODE=sql]select * from pg_language;[/CODE]
Here's the result for this step:
...Code:lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl ----------+---------+--------------+---------------+--------------+--------------- internal | f | f | 0 | 2246 | c | f | f | 0 | 2247 | sql | f | t
Leave a comment:
No activity results to display
Leave a comment: