CodeIgniter Forums - Search Results

Search Results

Thread: Hidden field not been submitted with form validation
Post: RE: Hidden field not been submitted with form vali...

The third parameter test

Thread: call function postgresql 9.5
Post: RE: call function postgresql 9.5

I tried with a simpler function. Code: -- DROP FUNCTION sp_1() CREATE OR REPLACE FUNCTION sp_1() RETURNS TABLE(codigo character varying, nombre character varying) AS $$ BEGIN RETURN QUER...

Thread: call function postgresql 9.5
Post: call function postgresql 9.5

I have not found help. Now I created a function in postgresql 9.5 CREATE OR REPLACE FUNCTION certificado_notas() RETURNS TABLE(mat_anio_academico integer, udi_id integer, udi_nombre character var...

Thread: remove the double quotes of a subquery
Post: RE: remove the double quotes of a subquery

I have not found help. Now I created a function in postgresql 9.5 CREATE OR REPLACE FUNCTION certificado_notas() RETURNS TABLE(mat_anio_academico integer, udi_id integer, udi_nombre character...

Thread: remove the double quotes of a subquery
Post: RE: remove the double quotes of a subquery

if you find the field! to correct the double quote and try pgadmin3 works. This is the modified query and running SELECT m.mat_anio_academico, mu.udi_id, u.udi_nombre, u.sem_codigo, u.udi_letra...

Thread: remove the double quotes of a subquery
Post: RE: remove the double quotes of a subquery

I returned to the simple example $subquery = 'SELECT DISTINCT ON (mud.udi_id) mud.mud_id FROM matricula_unidad_didactica AS mud INNER JOIN matricula AS m ON mud.mat_id=m.mat_id INNER JOIN alumno AS...

Thread: remove the double quotes of a subquery
Post: RE: remove the double quotes of a subquery

thanks for you help. i'm trying with the next code in the subquery. $this->db->order_by('u.sem_codigo', 'ASC'); $this->db->order_by('u.udi_letra_nomina','ASC'); $this->db->order_by('m.mat_anio_ac...

Thread: remove the double quotes of a subquery
Post: remove the double quotes of a subquery

¿how do I remove the double quotes of a subquery in postgresql? i have the example next: Error Number: ERROR: syntax error at or near "AS" LINE 7: ...d"."udi_id" DESC, "m"."mat_anio_academico...