,ch04.13730 Page 193 Wednesday, November 29, 2000 4:43
,ch04.13730 Page 193 Wednesday, November 29, 2000 4:43 PM Table 4-10: PostgreSQL Supported Functions (continued) Function position(string in string) pow(float8,float8) popen(path) reltime(interval) radians(float8) radius(circle) round(float8) rpad(text,int,text) rtrim(text,text) sin(float8) sqrt(float8) substring(string [from int] [for int]) substr(text,int[,int]) tan(float8) text(char) text(varchar) textpos(text,text) timestamp(date) timestamp(date,time) to_char(timestamp, text) to_char(int, text) to_char(float, text) to_char(numeric, text) to_date(text, text) to_number(text, text) to_timestamp(text, text) translate(text,from,to) trim([leading|trailing| both] [string] from string) trunc(float8) upper(text) varchar(char) varchar(text) width(box) Description Returns location of specified substring Raises a number to the specified exponent Converts path to open path Converts to reltime Converts degrees to radians Returns radius of circle Rounds to nearest integer Converts right pad string to specified length Converts right trim characters from text Returns sine Returns square root Extracts specified substring Extracts specified substring Returns tangent Converts char to text type Converts varchar to text type Locates specified substring Converts to timestamp Converts to timestamp Converts timestamp to string Converts int4/int8 to string Converts float4/float8 to string Converts numeric to string Converts string to date Converts string to numeric Converts string to timestamp Converts character in string Trims characters from string Truncates (towards zero) Converts text to uppercase Converts char to varchar type Converts text to varchar type Returns horizontal size Functions Vendor Extensions 193
Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost PHP MySQL Web Hosting services