PostgreSQL 8.0.0 ��ĵ��PostgreSQL �й� ��
Prev	Fast Backward		Fast Forward	Next

II. SQL ��

��һ�� PostgreSQL �� SQL ��Ե�ʹ�á��Ǵ�� SQL ��һ��﷨��ʼ�� Ȼ��δ��ݵĽṹ��ݿ⣬�Լ��β�ѯ��ݿ⡣ �м䲿��г��û�� SQL ��п��õ��ͺͺ�� ʣ�µĲ��Щ�Ե��ݿ⣬�Ż��ܺ��Ҫ�ļ��档

��һ��ֵ��Ϣ��ŵģ��ֿ��Դ�ͷ��β�� Ի�ȡ�й��˽⣬��Ҫ��ǰ��̫��Ĵ�� ½��Ƴ��԰��ģ��߼��û��Ϳ��ѡ��½��Ķ�� ⲿ�ֵ��Ϣ�ǰ��ⵥԪ��ķ�ʽ��֯�ġ� ��Ҫ�˽��ض��ôӦ�ÿ�� Part VI��

��Ķ��Ӧ��֪��һ�� PostgreSQL ��ݿ��Ӳ�� SQL �� ��ǽ��Щ��Ϥ��Щ��Ķ��Ķ� Part I�� ͨ�� SQL �� PostgreSQL ��ն� psql ��ģ��ƹ��ܵĳ��Ҳ��ʹ�á�

Table of Contents

4. SQL �﷨

4.1. �ʷ��ṹ
4.2. ֵ��ʽ

5. ��ݶ��

5.1. ��Ļ��
5.2. ϵͳ�ֶ�
5.3. ȱʡֵ
5.4. Լ��
5.5. �̳�
5.6. �޸ı�
5.7. Ȩ��
5.8. ģʽ
5.9. ��ݿ��
5.10. ��׷��

6. ��ݲ��

6.1. ��
6.2. ��
6.3. ɾ��

7. ��ѯ

7.1. ��
7.2. ��ʽ
7.3. ѡ��б�
7.4. ��ϲ�ѯ
7.5. ��
7.6. LIMIT �� OFFSET

8.1. ��ֵ��
8.2. ��
8.3. �ַ��
8.4. ��
8.5. ��/ʱ��
8.6. ��
8.7. ��
8.8. ��ַ��
8.9. λ��
8.10. ��
8.11. ��
8.12. ��ʶ��
8.13. α��

9. ��Ͳ��

9.1. �߼��
9.2. �Ƚϲ��
9.3. ��ѧ��Ͳ��
9.4. �ַ��Ͳ��
9.5. ��ִ��Ͳ��
9.6. λ��Ͳ��
9.7. ģʽƥ��
9.8. ��͸�ʽ��
9.9. ʱ��/��ں��Ͳ��
9.10. ��κ��Ͳ��
9.11. ��ַ��ͺ��Ͳ��
9.12. ��в��
9.13. ��ʽ
9.14. ��麯��Ͳ��
9.15. �ۼ��
9.16. �Ӳ�ѯ��ʽ
9.17. �к��Ƚ�
9.18. ��ؼ��ϵĺ��
9.19. ϵͳ��Ϣ��
9.20. ϵͳ��

10. ��ת��

10.1. ��
10.2. ��
10.3. ��
10.4. ֵ�洢
10.5. UNION��CASE �� ARRAY��

11.1. ��
11.2. ��
11.3. ��ֶ��
11.4. Ψһ��
11.5. ��ʽ�ϵ��
11.6. ��
11.7. ��
11.8. ��ʹ��

12.1. ��
12.2. ��
12.3. ��ȷ��
12.4. Ӧ�ò��Լ��
12.5. ��

13.1. ʹ�� EXPLAIN
13.2. �滮��ʹ�õ�ͳ��Ϣ
13.3. ��ȷ�� JOIN ��ӣ��ƹ滮��
13.4. ��ݿ��Ӽ�¼

Prev	Home	Next
��		SQL �﷨