Real Name	:	Secure Shell
Subject	:	Using substring() function for PostgreSQL
Description	:	Using substring() function for PostgreSQL database / PostgreSQL veritabanında substring fonksiyonu kullanımına örnek. Fonksiyon sayesinde ilgili field in başlangıç ve bitiş noktası belirterek gerekli field kısmı alınabiliyor.
postgres=# select * from employee; id | name | salary | start_date | city | region ----+--------+--------+------------+-----------+-------- 1 | Jason | 40420 | 1994-02-01 | New York | W 2 | Robert | 14420 | 1995-01-02 | Vancouver | N 3 | Celia | 24020 | 1996-12-03 | Toronto | W 4 | Linda | 40620 | 1997-11-04 | New York | N 5 | David | 80026 | 1998-10-05 | Vancouver | W 6 | James | 70060 | 1999-09-06 | Toronto | N 7 | Alison | 90620 | 2000-08-07 | New York | W 8 | Chris | 26020 | 2001-07-08 | Vancouver | N 9 | Mary | 60020 | 2002-06-09 | Toronto | W (9 rows) postgres=# postgres=# SELECT name, substring(name FROM 3 FOR 5) postgres-# FROM employee postgres-# ORDER BY name DESC; name | substring --------+----------- Robert | bert Mary | ry Linda | nda Jason | son James | mes David | vid Chris | ris Celia | lia Alison | ison (9 rows)
Rating	:	0.00 (out of 5)

Visitor Voting Booth

:

ExcellentVery GoodGoodFairPoor