Ajax
ASP
C,C++
C#,.NET
CSS,HTML
Delphi,Kylix
Experience
Flash
Java
JavaScript
PHP
Python
QT
SQL
ShellScript
VB
U :
P :
Register
Lost Password
Other Links
Code Archive
Save Giovanni
SQL Category Code
Real Name
:
Secure Shell
Subject
:
Using char_length() for PostgreSQL
Description
:
Using char_length() for PostgreSQL database / PostgreSQL veritabanında char_length fonksiyonunu kullanma. Fonksiyon sayesinde belirtilen field in karakter uzunluğu hesaplanabilir ayrıca bunları şartlarda kullanabilirsiniz.
postgres=# postgres=# CREATE TABLE test1 (a character(4)); CREATE TABLE postgres=# postgres=# INSERT INTO test1 VALUES ('ok'); INSERT 0 1 postgres=# SELECT a, char_length(a) FROM test1; a | char_length ------+------------- ok | 2 (1 row) postgres=# postgres=# drop table test1; DROP TABLE postgres=# postgres=#
Rating
:
5.00
(out of 5)
Visitor Voting Booth
:
Excellent
Very Good
Good
Fair
Poor
Copyright © 2006 SharingCode.NET . All rights reserved. Hosted By: SisNetworks